Re: Optimize A Simple Query -- Help

Chao - have you tried "update statistics medium..." or high...? That might induce the optimizer to choose the more discriminating index. If you're running "low", the optimizer is flying pretty blind when it comes to data distributions. Greg Chao Y. Din wrote: > > I have a simple select count statement that takes three minutes to > execute, yet I only have about 300,0000 rows. Here is the SQL. > > SELECT COUNT(*) FROM table WHERE key[1,7] = "B02800A" AND col1 = 2010 > AND col2 = 10;> snip.... > Is it possible to force the query to use index on key without dropping > the composite index? > snip...