Select with 5 different options
Posted on 2006-06-29
Here is my problem.
I have a database table with a lot of fields but the most relvenat fields are:
There is many users in many offices who make many operaitons over many products of many types.
I am giving the user the choice of select One or all the offices with one or all the users (There are many users in each office) with one or all the operations with one or all the products with one or all the types.
I need a solution to make a search the most efficient possible because the number of records in the table is thousands more than 500000 and this is for a simple consult that need to be as quickcly as possible.
Hope any one can help me, ask me for further information.