Help: Whats Clustering???

[pritisg]

Hey All,

Iam Preethi, and having my DBA interview on friday 17th sep...im havin some 6+ months exp, and the requirement its basically on clustering and PT, replication. And i hav no idea abt clusterin, and PT is just ok. :-(

guys please help me out...give some good stuff so i can pass my interview...

Thanks in Advance

Regards
Preethi

[madhu]

Hello Preethi,

Cluster analysis is a powerful way to organize rows in the dataset into groups or clusters of similar rows.

If the value for the clustering factor is near the number of table blocks, it means the index is well ordered; conversely, if the value is near the number of rows in the table, the index is not well ordered (unless the row size is close to blocksize). Indexes with high clustering factors indicates that under index scan conditions, the same blocks will be read numerous times.

I am attaching a small document on clustering. Good luck with your interview.

Madhu (Admin)

[file name=clustering.pdf size=45183]http://www.exforsys.com/components/com_simpleboard/uploaded/files/clustering.pdf[/file]

[pritisg]

Dear Madhu,

thanks for the reply and the info, doc.......