>    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

either use query analyzer, w/show plan, show stats, etc,turned on or
in TSQL use
SET SHOWPLAN_ALL ON
SELECT *
FROM someTable
WHERE yadda=yadda
SET SHOWPLAN_ALL OFF




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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

Reply via email to