Re: My sql and indexing

2001-05-24 Thread Jeremy Zawodny
On Thu, May 24, 2001 at 04:07:48PM +0100, VVM Ravikumar Sarma Chengalvala wrote: > I would like to have answers/confirmation regarding > the following: > i) > Primary and Unique key fields are autoindexed by > mysql. Yes. > ii) > Indexing on a single or multiple fields will create a > overhead

My sql and indexing

2001-05-24 Thread VVM Ravikumar Sarma Chengalvala
Hi, I would like to have answers/confirmation regarding the following: i) Primary and Unique key fields are autoindexed by mysql. ii) Indexing on a single or multiple fields will create a overhead on database memory.To what extent iii) Indexing Vs Perfromance based on a query frequency on a part