Composite Index

• Used when columns have a logical relationship and would be searched as a unit

• Example
  create index au_name_ind
  
  on authors (au_lname, au_fname)

• order not important, but performance is better when primary search col is first

Previous slide

Next slide

Back to first slide

View graphic version