Thanks for you replies.
I have the table which contains some properties of the document in my knowledge repository.
The user can search by specifying any values to the properties.
Based on the values in the properties the where criteria is framed and then I am sending this to the stored procedure.
In the stored procedure I am framing the dynamic query with the where clause with the input where clause.
The table has minimum more than 200000 documents.
So I don't know how to make the index.
I had a discussion and some were saying that I can have index for all the fields.
Can any one tell me how to resolve this?
Thanks a lot.
Nothing is impossible with Hard Work