I know this is OT, but I figure there's some people pretty familiar w/ M$
SQL Server in here.
I need to do some cost-based analysis on SQL Server queries, making sure
it's properly using the indices, relative costs of each section, etc. I'd
like an SQL command akin to Postgre's EXPLAIN for some manual tinkering.
I've searched the MSDN T-SQL guide but can't seem to find anything.
For those not familiar w/ Postgre's EXPLAIN, here's a sample output:
EXPLAIN
SELECT *
FROM table_name
WHERE cid=1
AND uid=2
ORDER BY sort_date DESC;
NOTICE: QUERY PLAN:
Sort (cost=2.14..2.14 rows=1 width=10)
-> Index Scan using usr_in_cat
on table (cost=0.00..2.02 rows=1 width=10)
EXPLAIN
Failing a command line return, if anyone knows of some free GUI utils (or
reasonable price)?
As you can tell I'm not overly familiar w/ SQL Server, so another info
request: Are there any nice tools akin Oracle's Cost-Based Optimizer for it?
Thanks,
Raymond B.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
