MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Index evaluation
Posted by: KimSeong Loh
Date: July 23, 2007 07:27PM

Why not this.

select t1.* from t1 join t2 as y on y.id = t1.id where y.txt like 'Hall%';

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Index evaluation
3297
Drei Bit
July 23, 2007 04:51PM
Re: Index evaluation
2282
Drei Bit
July 23, 2007 05:18PM
Re: Index evaluation
2238
KimSeong Loh
July 24, 2007 02:06AM
Re: Index evaluation
2238
Drei Bit
July 24, 2007 04:33AM
Re: Index evaluation
2263
KimSeong Loh
July 23, 2007 07:27PM
Re: Index evaluation
2220
Drei Bit
July 24, 2007 05:24AM


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.