Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
index on column with 2 possible values 1
- Thread starter nego78
- Start date
-
1
- #2
TonyGroves
Programmer
If the two values occur roughly equally often, then the query optimiser will usually ignore any index, so there is no point in having one, as it would only slow down updates. However, if one particular value predominates, then it could make sense to have an index.
ericbrunson
Technical User
My experience in Oracle (if applicable to MySQL) was that using a standard b-tree index on a field like that usually slowed the query down. Oracle has a "bitmap index" that handles those types of keys efficiently, but I'm not aware of a similar feature in MySQL.
- Status
Similar threads
- Locked
- Question