Finding the fractional second cost on a query 1

[link9]

As I'm reading around on the performance gains from an INNER LOOP JOIN vs. INNER JOIN, I keep seeing these measures in .'s of a second.

However, I do not see where to find that information when I run a query. The closest I'm seeing are full seconds, and I'm getting 1 second on either one --

Can someone point me to where I might find these exact performance measures so I can decide what to do with my queries?

Thanks!
Paul Prewett

 

[link9]

anyone?

 

[tlbroadbent]

How are you measuring the time statistics? If you select Query | Current Connection Properties and select Set Statistics Time, you should see times measured in milliseconds. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[link9]

Thanks, Terry.