>HI,
>I have a table containing 1 500 000 rows. When I make a query on it, it takes long time to execute. Is there a way to speed up the query by using indexes or by execute it asynchronously (SPT, or ADO). My 1,5M rows table is local.
>
>Thank you,
>Christian
If your table is local and you are searching on your primary key, it is faster to use SEEK() as opposed to SQL. IF the table is on the server, (remote) then the fastest results will be gained through a stored procedure in the server database that is activated by your query.
MSCE, MCSP, Microsoft Channel Partner
Relax, Boss. We will meet the deadline! What? You want to add MORE? What do you mean, Over Budget?
Opinions and comments are the sole responsibility of the sender, and accuracy, correctness, or pertinence is considered coincidental.