Brandie Tarvin (11/18/2009)
Sorry, GSquared. I have an anti-ditto (of a sort) to your list.RE: Indexing. Yes, index. But don't OVER index.
Pet Peeve = developers add an index to an existing table just so their query will run faster, not realizing the table already has a nearly 1:1 column to index relationship. And it never occurs to them that sometimes indexes can be Bad Things.
"Query running slow? Why re-write it when we can slap an index on the table?"
@sigh.
Rant over. Soapbox away.
Which is why I summarized to "index appropriately".
If I remember correctly, I once ran into a 10-column table with 50 indexes on it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon