Sasi Kiran Patha Warnings : 2 New User
Joined: 19 Nov 2006 Posts: 73 Location: Hyederabad
|
|
|
|
Hi Guys,
Lets Consider the below Example
Select * from XYZ Table
Where (Cond 1) AND
(Cond 2) AND
(Cond 3) AND
(Cond 4)
Now in the above example lets suppose the execution of COND 1 resulted in the retrieval of Zero records from the table. In that case does the DB2 System Quit with out executing the rest of the Conditions (COND 2, COND 3, COND 4) as the first Condition got failed or it proceeds ahead and Checks for the remaining Conditions also (COND 2, COND 3, COND 4)
Thanks,
Sasi Patha |
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
Sasi Patha,
Unfortunately, or fortunately, it?s not that simple. DB2 analyses your SQL and determines the best approach to satisfying you query. It?s not a top down execution. |
|