Secondary Indexing |DBMS-Tutorial 4
In Secondary Indexing,the index is created on some non ordering filed of the datafile.The non ordering field is the field on which the file is unordered or physically unsorted on the disk.For every data record,there will be an entry in the secondary index.The number of entries in the secondary index is equal to the number of records of the datafile.It can be considered as a secondary access method for which some primary access such as primary index or clustered index already exists.
#secondaryindexing
#secondaryindexingindbms