48 Indices on Multiple Attributes With the where clause where branch-name = Perryridge and balance = 1000 the index on the combined search-key will fetch only records that satisfy both conditions.
{"Image DocumentName": "Indices on Multiple Attributes", "Image ImageDescription": "Suppose we have an index on combined search-key. (branch-name, balance). With the where clause where branch-name = Perryridge and balance = 1000 the index on the combined search-key will fetch only records that satisfy both conditions. Using separate indices in less efficient \u2014 we may fetch many records (or pointers) that satisfy only one of the conditions. Can also efficiently handle where branch-name - Perryridge and balance < But cannot efficiently handle where branch-name < Perryridge and balance = 1000 May fetch many records that satisfy the first but not the second condition.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}