October 14, 2003 at 5:33 am
SELECT x,y,z
FROM A
LEFT JOIN B AS b1
LEFT JOIN B AS b2
WHERE condition
ORDER BY A.h
this is a skeleton of a query
out of curiosity i tried finding its execution time just to find myself nowhere near the result
can anyone tell me how the execution will actually go about
October 14, 2003 at 5:57 am
I hope U get what U want from Execution palns. We can set it from QA(QueryAnalyser). Just go to Query option in QA and select Show execution plan. or
Other wise by using SET SHOWPLAN_ALL & SET SHOWPLAN_TEXT ON/OF also we can veiw the execution time.
Madhu
Madhu
December 12, 2003 at 1:38 am
If you really want only the execution time taken for the query, then simply declare a variable and store the result of gatdate() in it ...now execute the query and then have another variable and store the difference of the getdate() and the first variable.
Cheers!
Arvind
Arvind
December 19, 2003 at 2:29 am
use SQL profiler tool to find out the execution time
Raj
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply