|
|
Posted by Chris Weston on 03/23/06 21:11
Hi.
Maybe I'm just being dim, but I'm struggling to get my head around
optimising a query with regard to indexes. If I make a select query, such
as a pseudo-example 'select * from bigtable where foo='bar' and
(barney>rubble and fred<flintoff)', and the table is indexed on 'foo', how
could I make that any better? What indexes could I add, or what could I
change in the query?
I know it looks simple, but so am I.
Cheers
Chris Weston
Navigation:
[Reply to this message]
|