Re: SQL Where clause order of operations?

From: Vjoshi2 <vjoshi2_at_aol.com>
Date: 11 Jul 1998 08:34:08 GMT
Message-ID: <1998071108340800.EAA12209@ladder03.news.aol.com>

HI,
The best way to judge what is actually happening is to do an explain plan on your statement.
The explain plan shows what path the optimzer takes to resolve your query.

I would put the last to statements in brackets so that they will have priority over the others.

I have to say explain plan is probably best at explaining query routes.

vjoshi_at_pinnacle.co.uk
vjoshi2_at_aol.com Received on Sat Jul 11 1998 - 03:34:08 CDT

This message: [ Message body ]
Next message: Vjoshi2: "Re: database link"
Previous message: Vjoshi2: "Re: What does Oracle think O/S block size is?"
In reply to: drpaner_at_intrex.net: "SQL Where clause order of operations?"
Next in thread: Jonathan Gennick: "Re: SQL Where clause order of operations?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US