|
|
Posted by Slower Than You on 11/21/06 03:27
deebeetwo@yahoo.com wrote:
> Slower Than You wrote:
> > Well I'm no expert, but surely the way to make it go faster is to
> > index detail_1 and detail_2?
> >
> > For every record selected in t1, the engine is comparing 40,000
> > records in t2. 40,000 x 40,000 is 1,600,000,000 operations.
>
>
> Yes, indeed the indexes helped the query. Thanks a lot!
Wow! You mean I was actually *right* about something? Well that makes a
pleasant change...
Glad to be of some assistance.
--
SlowerThanYou
Navigation:
[Reply to this message]
|