List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:August 1 2005 2:01pm
Subject:RE: query unexpectedly took too long.
View as plain text  
[snip]
> Proper indexing will solve your problem. Index bdate and level, that
> should speed things up considerably.
> 

From the looks of things, bdate and level are *already* indexed. Or, did
you want him to create a multi-column index on bdate and level? You
weren't very clear in your suggestion. 
[/snip]


I read through the Ops e-mail too fast and missed the indexes. Ah
well...
Thread
query unexpectedly took too long.jpyeron1 Aug
  • Re: query unexpectedly took too long.SGreen1 Aug
RE: query unexpectedly took too long.Jay Blanchard1 Aug
  • RE: query unexpectedly took too long.SGreen1 Aug
  • RE: query unexpectedly took too long.Jason Pyeron1 Aug
RE: query unexpectedly took too long.Jay Blanchard1 Aug