Secondary Indices Frequently,one wants to find all the records whose values in a certain field(which is not the search-key of the primary index)satisfy some condition. Example 1:In the account relation stored sequentially by account number,we may want to find all accounts in a particular branch Example 2:as above,but where we want to find all accounts with a specified balance or range of balances We can have a secondary index with an index record for each search-key value Database System Concepts-5th Edition,Oct 4,2006 12.13 @Silberschatz,Korth and SudarshanDatabase System Concepts - 5 12.13 ©Silberschatz, Korth and Sudarshan th Edition, Oct 4, 2006 Secondary Indices Frequently, one wants to find all the records whose values in a certain field (which is not the search-key of the primary index) satisfy some condition. Example 1: In the account relation stored sequentially by account number, we may want to find all accounts in a particular branch Example 2: as above, but where we want to find all accounts with a specified balance or range of balances We can have a secondary index with an index record for each search-key value