Path: utzoo!attcan!uunet!van-bc!ubc-cs!alberta!ncc!ice9!bgh
From: bgh@ice9.uucp (barry hannigan)
Newsgroups: comp.databases
Subject: Re: Oracle vs. Sybase on Sun 4:  That much difference!?
Message-ID: <1990Mar22.142349.1914@ice9.uucp>
Date: 22 Mar 90 14:23:49 GMT
References: <1990Mar14.205620.11636@lia> <106035@pyramid.pyramid.com> <404@ohsuhcx.ohsu.edu> <1990Mar22.044059.26644@oracle.com>
Reply-To: bgh@ice9.uucp (barry hannigan)
Organization: icicle systems
Lines: 13

[stuff deleted]
>EXPLAIN and TKPROF are documented in Chapter 7 of "Performance Tuning Guide",
>Part # 5317-v6.0

and of little use in real life. explain [sql] examines the execution trace 
without actually running the statement. i much prefered the trace() statement
which could be included in sqlforms to examine everything. cryptic output but
when isnt it.

when i was taught sql, one of the driving points was that it was an
non-procedural language. apparently that was marketting stuff.
-- 
return path = uunet!alberta!ncc!ice9!bgh