|
|
Posted by deebeetwo on 11/20/06 16:33
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!
> Of course, I might be talking nonsense...
> --
> SlowerThanYou
Navigation:
[Reply to this message]
|