sql question
netters,
can someone explain why the optimizer doesnt short circuit on the following
query:
QUERY:
------
select *
from book_bill_back
where 1=2
Estimated Cost: 370832
Estimated # of Rows Returned: 4330952
1) book_bill_back: SEQUENTIAL SCAN
Filters: 1 = 2
regards,
+----------------------------------------------------------------------------+
| . . | |
| ... ... | Bob Baskett |
| ..... ..... | Software Engineer, DBA |
| .. ... .. | Business Systems Integration Group |
| . . . | Semiconductor Products Sector |
| | Mesa, AZ |
| Motorola, Inc. | |
|----------------------------------------------------------------------------|
| 'connectionLESS IS MORE' -- Data Broker |
|----------------------------------------------------------------------------|
| Duct tape is like the force. It has a light side, and a dark side, and |
| it holds the universe together ... |
| -- Carl Zwanzig |
+----------------------------------------------------------------------------+