|
|
Posted by Slower Than You on 11/17/06 19:26
newtophp2000@yahoo.com wrote:
> The table in question is quite simple and is created as follows.
> There are no indexes on the table:
>
> create table user_details (id integer, detail_1 varchar(50),
> detail_2 varchar(50)
>
>
> Is there a way to make it go faster?
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.
Of course, I might be talking nonsense...
--
SlowerThanYou
Navigation:
[Reply to this message]
|