I have a table that is roughly like the below: id - PK, autoincremented integer name - varchar visit - timestamp action - char(10)
Now, 'action', while a char(10), is only ever intended to contain two possible values, "purchase" and "preview". The table might end up containing tens or even hundrds of thousands of rows and a report will eventually be generated that differentiates between "purchases" and "previews". Should I still create an index on the 'action' column and of how much benefit will it be ? Thanks in advance for your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
