Abedalrahim -

that speed metric sounds very slow - almost as if you are performing a table scan during each iteration inside your WHERE clause .

Lets assume for the moment that the fields/columns used in your query ARE NOT INDEXED at the back end.

So - to decrease the return time, you will need to add indices on those columns at the back end database.

The question now becomes:
1. do you have rights to do this?
2. will you violate any support agreement by adding indices to some other vendors database schema ?

Take apart your WHERE clauses - look at each field/column that you want to use. Check to see in the vendors database if there is actually an index on each column that you are using in your WHERE clauses.
Suggest you actually add the indices at the back end, or in a copy of the back end.

hth - mondo regards [Bill]
I am repeating myself on purpose - the answer is the same.
YOU WANT SPEED ? INDEX YOUR TABLES based on stuff in your where clauses.

>Hi ,
>
>I did not made any indexes for these 3 tables whene I added to a querey because when i make any index it give me an error, I want to ask you if i can to send you a pic for the structure of this querey and i think you will know why the querey is very slow.
>
>
>Thanks for your time