MySQL Forums
Forum List  »  Optimizer & Parser

Re: Problem with index and left join
Posted by: Erland Isaksson
Date: May 09, 2006 10:44PM

The problem is that I don't own the tracks table, its handled by an external product. The track_statistics table is my own and the only stable reference I can have from my table is the tracks.url column.

I just tried changing the track_statistics.url to a varchar(255) and then the index works correctly. So the problem seems to be the TEXT database type in combination with the left join. The index works with TEXT database type with a simple select with no join, so it seems to be the combination of TEXT and LEFT JOIN that causes the index not to be used.

The problem with using varchar(255) is that I can't be sure that urls always are shorter than 256 characters.

Any ideas are greatly appreciated

Options: ReplyQuote

Written By
Re: Problem with index and left join
May 09, 2006 10:44PM
May 09, 2006 11:48PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.