Re: Problem with index and left join
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
Subject
Views
Written By
Posted
4494
May 05, 2006 03:04PM
2450
May 09, 2006 06:17PM
Re: Problem with index and left join
2527
May 09, 2006 10:44PM
2260
May 09, 2006 11:48PM
2270
May 10, 2006 10:52AM
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.