INDEX'd fields...any drawbacks?

[woody at nfri dot com]

I have a database, about 12 fields per record and roughly 100,000
records per month.

I would do the following query:

select count(*), type from TABLENAME where field0='23-23-23' group by
type;
the query would run an average of about 2secs. Not bad until I am
running the same query about 1400 times all with slightly different
field0 values.

I added an index for field0...with:
alter table TABLENAME add index (field0);

Now those same queries run about an average of 1/10th of a sec!! My
question is, is there a negative effect by indexing this field?

Obviously you woudn't index all fields...but could you?

Thanks,
--
Woody

In a world without boundaries why
do we need Gates and Windows?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw