Speeding up select queries on table with 3million rows.

External Since: Feb 08, 2005 Posts: 2

On 1 Feb 2005 13:20:31 -0800, mfyahya RemoveThis @gmail.com wrote:

>Thank you for the suggestions. The queries are taking around 2 secs
>after I created separate indexes and changed varchars to chars. How
>does google do it in milliseconds?? Is it just super hardware?
>
>What happens when there are both multicolumn and single column indexes?
>Which one does MySQL use?
>
>I'd appreciate if anyone could suggest a good introductory book on
>these database topics. I find this fascinating.
>
>Yahya

"MySQL" by Paul DuBois covers a lot of these topics pretty well.