Re: Queries returning large number of rows
For that query, the index will not work. MySQL can only use an index if you use a prefix of it. So your index on (current_entry, previous_entry) will work for:
... WHERE current_entry LIKE 'whatever%';
... WHERE current_entry LIKE 'foo%' AND previous_entry like 'bar%'
But not for:
... WHERE previous_entry LIKE 'whatever%'
For the latter you need an index that starts with previous_entry.
Subject
Views
Written By
Posted
5500
May 22, 2006 06:21AM
Re: Queries returning large number of rows
1891
May 22, 2006 09:04AM
1726
May 22, 2006 10:28AM
1747
May 23, 2006 07:13AM
1775
May 23, 2006 01:02PM
1558
May 24, 2006 07:08AM
1500
May 24, 2006 09:19AM
1645
May 24, 2006 10:18AM
1715
May 24, 2006 11:53AM
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.