A good thread on the differences between using a single wide index or multiple single column indexes on a table in a database for query speed an stuff.

http://p2p.wrox.com/topic.asp?TOPIC_ID=649

• The first column of a multi-column index DOES also function as a single column index on the first field.
  

Related Scribbles:

SQL Syntax, Query Examples and Notes

---

ID: 666
Author:
leonard
Date Updated:
2005-07-26 11:45:34
Date Created:
2005-07-26 11:45:34

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> Multi-Column vs Multiple Single Column Indexes

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.