596 views
0 votes
0 votes
What is the Difference between Primary and Clustering Index or both are actually the Same ?

2 Answers

0 votes
0 votes
primary:- Primary clustering are made on using key attribute of the relation. so the actual record and the index file are arranged in same order. while making primary index we generally store the first value of the block so generally its sparse index.

clustering index:- clustering index is maintained for every search key value. these search key value can be repeated and since index is maintained for every search key value the index file become dense.
0 votes
0 votes

primary Index

  • indexing should be in ordered .
  • indexing must be on key attribute.
  • sparse index is used

Clustering Index

  • indexing should be in ordered .
  • indexing must be in non- key attribute.
  • dense index is used.

example

Related questions

0 votes
0 votes
0 answers
1
2 votes
2 votes
1 answer
3
3 votes
3 votes
1 answer
4
Na462 asked Jan 26, 2019
1,813 views