UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

ATTN db gurus	by imrambi	2008-10-21 10:58:29
I think so.	by aix tom	2008-10-21 11:05:43
It's not quite clear, what you mean. ;-) If you have "columnB='bar' and columnA='foo'" in the where clause, (or A/B swapped) then yes, one index on columnA and columnB would help. Whether you should put columnA or columnB first in the index doesn't really depend on the order in the query, but more on how the data is distributed in the table. E.g. how many similar values are in columnA as opposed to columnB. Can the DB you use display an execution plan?
[ Reply ]
I'm using multiple dbs (n/t)	by imrambi	2008-10-21 11:10:32
What I can say is that in all the DBs I use	by aix tom	2008-10-21 11:13:21

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)