Using the Search Feature scenario, I would like to get opinion to design/implement search functionality.
For Example :
An Employee data stored in the table.. I would like to search employee for one or many combination of search criteria of attributes of Employees.
- Joining Date
- Active Employee
and many more other criteria.
On screen I can give values for either of these or all criteria.
How should we proceed to implement this scenario specially table design. I am not sure if we need to create tables for all possible combination of these criteria ( keeping as partition and cluster keys).