How do you evaluate performance ?
Using SQL TRACE. It is an utility that can monitor and report on database performance when one or more queries are run against the database.
It is used to gather statistics when running the query (i.e) reports on CPU time spent on the query, the total no. of rows processed and statistics related to parsing and cache performance.