Hi Guys,
I have a large (50 million records) demographic table, normalized, with about 10 searcheable fields (annual income, number of children, etc etc) all searchable fields are id's related to smaller tables.
The query I will run against the db is a classic multiple options choice :
Income : 1.All 2.Between X and Y 3.Between J and K
Children : 1.All 2.None 3.Between X and Y
etc
What is the best approach in your opinion coming to indexing ? Should I index all searcheable fields, combine fields or ... ?
Any advise very much appreciated.
Thanks !
--
PG
I have a large (50 million records) demographic table, normalized, with about 10 searcheable fields (annual income, number of children, etc etc) all searchable fields are id's related to smaller tables.
The query I will run against the db is a classic multiple options choice :
Income : 1.All 2.Between X and Y 3.Between J and K
Children : 1.All 2.None 3.Between X and Y
etc
What is the best approach in your opinion coming to indexing ? Should I index all searcheable fields, combine fields or ... ?
Any advise very much appreciated.
Thanks !
--
PG