Re: Index Keys of the table
Posted by:
fei lee
Date: November 01, 2012 08:05PM
Dear Rick,
Thanks for your response!
To answer your questions:
There are 2,000,000 records in the table. Size of table is 405MB.
Yes, I will be using LIKE %...% rather than '=' in my queries.
- LIKE %...% for Name, Email, Phone
- '=' for Gender, DOB
Table Type is MYISAM
After reading the page you recommended, I *feel* that compound key is better?
Subject
Views
Written By
Posted
2966
October 28, 2012 11:01PM
1694
October 30, 2012 11:59AM
Re: Index Keys of the table
1610
November 01, 2012 08:05PM
1676
November 02, 2012 08:21PM
1350
November 04, 2012 08:54PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.