how to test the speed of SQL processing in SQL...

[NinjaTurtle]

Dear,

im now have two different SQL Statements and i want to test out the speed of this two SQL Statements, what should i do? like i want is show the processing usage time? posssible?

[allida77]

Try this:
http://www.indus-soft.com/winsql/

Look for the "WinSQL Lite - FREE" utility.

I use this tool all the time at work.
If you happen to have MSSql server there is a "Query Analyzer" tool that installs with MS SQL Server.

[NinjaTurtle]

Yes, i do have Query Analyzer but how to check the time usage?
is that the Statistic tab?

[Morgoth]

You mean like how long it takes the page to load while doing sql stuff???

http://www.askasp.com/articles.asp?ArtID=85