Should I use an index in this case?

[Andy Sy]

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.