MySQL Forums
Forum List  »  Newbie

Creating an Index
Posted by: Ann-Marie Otoole
Date: March 13, 2012 09:23AM

I have a read mostly write rarely data file with about 2,000 entries that gets accessed up to 400,000 times a day. I want to speed up access by indexing but don't know too much about it. The records are not very large, total storage about 800K.

Access typically selects from 1 to 10 records from one column that have a common data value so that parameter would be the one to index. When I try to set it as a primary index it gets rejected, I assume because there is more than one record with the same index value.

In order to create an index I would have to add a second column of discrete data but data that is virtually never needed.

Does an index like this provide any advantage in accessing speed?
When I create it, the index occupies about 125K or 16% the size of the whole data file.

Options: ReplyQuote

Written By
Creating an Index
March 13, 2012 09:23AM
March 13, 2012 11:07AM
March 15, 2012 11:09AM
March 15, 2012 06:40PM
March 18, 2012 01:45PM
March 18, 2012 08:07PM
March 20, 2012 09:06PM
March 20, 2012 09:57PM
March 22, 2012 07:15PM
March 21, 2012 05:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.