optimaze queries

From: Shaochun Lin <lovedog_at_gwis2.circ.gwu.edu>
Date: 1996/01/21
Message-ID: <4dseco$i3q_at_cronkite.seas.gwu.edu>#1/1

        I have a query need to be optimazed and generate the comparsion report. I know I should use tkprof. But what's the right procedure to do this. Is it:

	start trace ( using alter session ...)
	run old query
	close trace ( using alter session ...)
	quit

	get in sql
	start trace
	run new query
	close trace
 	quit

	And then use tkprof generate the report and do the comparsion. Is

it a right procedure or not. Any comments would be greatly appreciated. Shaochun,           Received on Sun Jan 21 1996 - 00:00:00 CET