in Databases reshown by
1,076 views
2 votes
2 votes
in Databases reshown by
1.1k views

2 Answers

1 vote
1 vote

A secondary index provides a secondary means of accessing a data file for which
some primary access already exists. The data file records could be ordered,
unordered, or hashed. The secondary index may be created on a field that is a candidate key and has a unique value in every record, or on a nonkey field with duplicate values.

From -> Navathe DBMS !

So we need to have primary index too. Assuming we used 1 column for that, we have 4 columns remaining, using which we can have max 4 secondary indexes !

0 votes
0 votes

secondary index is on unordered attribute . a file with 5 attributes, to find secondary indices on this  based on one remaining will be ordered so there are 4 secondary indices  possiblesmiley

Related questions