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.
Using a sql server execution plan
-
- Devart Team
- Posts: 925
- Joined: Thu 17 Nov 2005 10:53