Database » Ask Tom MOST RECENT ARTICLES » Multiple concatenated column indexes or single column indexes?

Feeds

14827 items (1495 unread) in 26 feeds

Database (1495 unread)

• DBA's notes (111 unread)
• $Pete Finnigan's Oracle security weblog (56 unread)
• Ask Tom MOST RECENT ARTICLES (350 unread)
• Databases News (83 unread)
• DBAzine.com - Oracle Articles Archive (4 unread)
• Eddie Awad's Blog (31 unread)
• FeuerThoughts (36 unread)
• Mark Rittman's Oracle Weblog
• MR. ED's blog (1 unread)
• MySQL Performance Blog (133 unread)
• Niall's Oracle Pages (17 unread)
• OraBlogs
• Oracle + Open Source
• Oracle HTML DB Studio Recent Additions (20 unread)
• Oracle Security Alerts (2 unread)
• Oracle Software Downloads (62 unread)
• Oracle Technology News (34 unread)
• Oracle's OTN TechCasts (21 unread)
• Orawin.Info
• OTN TechBlog (72 unread)
• OTN/DBA
• Published Security Alerts
• The Dizwell Blog
• The Tom Kyte Blog (18 unread)
• TheServerSide.com (444 unread)
• Upcoming Security Alerts

Ask Tom MOST RECENT ARTICLES

• October 09, 2008
• 

  Multiple concatenated column indexes or single column indexes?

  Fetched: October 8th, 2008, 3:40am PDT

  Tags:    [edit]

  When I design tables, I've always added indexes to the columns that were used in WHERE clauses in queries. If the columns were used in multiple WHERE-clause combinations, I index each one of the columns that are being used. I found an application w...