Using a sql server execution plan
Posted: Tue 09 Mar 2010 11:41
In my application I use a very complex query. When I run that query in SQL Server management studio it takes 16 seconds to execute the first time and 2 seconds the second time. This is because the query execution plan is created.
When using it from Delphi application it is always like the first time (very slow).
Is it a way I can assign an execution plan to a query or any way I can use sdac to take advantage of this?
Or are you aware to another way to do it even if sdac doesn't support this?
Thanks.
When using it from Delphi application it is always like the first time (very slow).
Is it a way I can assign an execution plan to a query or any way I can use sdac to take advantage of this?
Or are you aware to another way to do it even if sdac doesn't support this?
Thanks.