we have a large table that i need to index.
here are the columns:
phone_number,
state,
revision_number,
data_month_year,
account_number,
File_date
I am assuming I shouldn't create an index for each column, should I?
The users will use any combination of these or maybe just one column in their where clause.
If i try to group them together, it may be something like:
date_month_year
or date_month_year & state & revision_number,
or date_month_year & phone_number
or date_month_year & account_number
State & file_date
or maybe all of them together?
thoughts on indexing, thanks.