indexing

Question

please can someone explain dense index ,sparse index ,cluster indexing with a proper example instead of theory ?

Answer 1

DENSE INDEX :If an index value is created for every search value.

SPARSE INDEX :If an index entry is created for some records.

CLUSTER INDEX: If an index entry is created on data files whose file record are physically ordered on a non key field.

Comments

so for dense if i have search key value 1 2 3 2 1 1 then index wil be created for all the entries right ?

and for cluster indexing if a non key value is repeating den dense index wil b used and if it not repeating den sparse index wil b used ?