What is Clustering? What are its types.

Database

CLUSTERING: If the page containing the requested record is already in the memory, retrieval from the disk is not necessary. In such a situation time taken for the whole operation will be less. Thus, if records which are frequently used together are placed physically together, more records will be in the same page. Hence the number of the pages to be retrieved is less and this reduces the number of disk accesses which intern gives a better performances. â€œThe method of storing logically related records, physically together is called clustering.â€

Types of Clustering::

INTRA FILE CLUSTERING: - Clustered records belong to the same file.
INTER FILE CLUSTERING: - Clustered records belong to different files. This type of clustering may be required to enhance the speed of queries retrieving related records from more than one table. Here interleaving records is used.

Gallery

Comments

Submit Reviews:

Rate

Review

Security Code

(Enter the characters seen on the image below.)

Promotional Ads

Packers and Movers in Chandigarh
Plot No 636, Near HP Gas Agency, Dariya, Chandigarh - 160101
Plot No 636, Near HP Gas Agency, Dariya, Chandigarh - 160101
Kurukshetra

Packers and Movers in Chandigarh
Plot No-123 Sunrise Colony Godown Area Pabhat Zirakpur-140603
Plot No-123 Sunrise Colony Godown Area Pabhat Zirakpur-140603
Jind

Packers and Movers In Satna - VP Max
Ground Floor, Shop 2, JL Institute of Study Center, Tilak Ganj, Ward 14, Sagar, Madhya Pradesh 470002
Ground Floor, Shop 2, JL Institute of Study Center, Tilak Ganj, Ward 14, Sagar, Madhya Pradesh 470002
Shahdol

Packers and Movers in Sagar
Ground Floor, Shop 2, JL Institute of Study Center, Tilak Ganj, Ward 14, Sagar, Madhya Pradesh 470002
Ground Floor, Shop 2, JL Institute of Study Center, Tilak Ganj, Ward 14, Sagar, Madhya Pradesh 470002
Sagar

Packers and movers in Mohali
Plot No 636, Near HP Gas Agency, Dariya, Chandigarh - 160101
Mohali

JB Rock Bolts & SN BOLTS
10 A & B Industrial Area (at Vill. Nangal Jarialan)
Distt. Una Himachal Pradesh
Una

Packers and Movers in Zirakpur - Packers and Mover
SCO 3 AKS 2, Bhabat Rd, near Post Office, Zirakpur

Website Design and Development
Bangalore
Hyderabad

JF Engineering Products LLP
Parhar Village, Near Vasai Fata, Eastern Express Highway, Vasai (E), Palghar,
Motilal Nagar Mumbai

Nandishwar Steel
51 M.G. Mahimtura Marg, 3rd Kumbharwada Lane, Opp. Durgadevi Garden
August Kranti Marg Mumbai