MySQL Forums
Forum List  »  Performance

Re: mysql not using index
Posted by: xnicnacx
Date: March 30, 2005 10:21AM

the application is a webspider, the query in total is select * from table where url = referer....it is used to see which pages linked to themselves......i still dont get the point why i cant use an index for that.... :/
url=url of the current page
referer=url where the link was found
is the problem related to the fields being of the type text or whats the problem....?
thx 4 your fast answer
NicNac

Options: ReplyQuote


Subject
Views
Written By
Posted
2666
March 30, 2005 07:05AM
1752
March 30, 2005 08:18AM
Re: mysql not using index
1710
March 30, 2005 10:21AM


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.