Re: Which is faster? <> or Between

Isaac Blank wrote:

> <snipped>
>
>
> Using a GUI tool to examine query plan is, in fact, a good thing - much
> easier to figure out the sequence of events and use my brain to do more
> important things. Maybe your managements prohibits use of calculators -
> after all, you can use your brain and a piece of paper instead - my
> management believes that proper tools enhance productivity and improve
> quality.

That is your opinion. One to which I strongly disagree. And your analogy is meaningless.

Using my brain or a calculator to produce an answer in mathematics will not produce different answers.
Using some company's GUI tool and SQL*Plus may, and does.

After you figure out how to install your GUI tool on my client's AIX servers with Solaris workstations I'll
let you take a whack at tuning their SQL. Until then I guess you're stuck in Windows.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)