How to list data effectively

[sricharan vemuri]

Hi all
I am charan, I have a question regarding the site http://shopgala.com on which I am currently working. The site has a left nav dropdown where I need to display all the stores in the table.

When I write the query ("select fld_1, fld_2 from tbl_name") it works fine. I know that because I use explain for each query I write which tells me if there are any extras and missing keys. Here is the tricky part while displaying the stores I need to display them in alphabetical order so I changed the query to be
("select fld_1, fld_2 from tbl_name order by fld_1 ASC") and when I use the explain it gives me its using filesort, temporary table.

How can I modify the query or table so that the query does not use filesort. Can I use indexes on varchar field.

Thank You
Charan