And on the fifth day, god said, "let there be indexing".

On Tue, Nov 18, 2008 at 8:29 PM, jarickuo <jarickuo@...> wrote:

--- In ydn-php@yahoogroups.com, "abhijit4u_2005" <abhijit4u_2005@...>
wrote:

>
> I want to retrieve those name whose last name starts with any alphabet
> (e.g T%) but the problem is on that table there are more then 8lakhs
> entries are there,it's take lot of time, the database is: MySql and
> query as follows:
> "SELECT name FROM `userinfo01` where `lastName` like 'T%'"
>
> some body help me that how can i optimize that query????????
>

Maybe you can try explain to verify your performance of query.

--
Johnny Fuery
Principal Engineer
jj@...
925.997.3878 Direct/Mobile
925.997.4107 Main
510-836-0915 Fax
Fuery Solutions
1736 Franklin Street, Suite 350
Oakland, CA 94612
http://fuerysolutions.com