Need Help optimizing SQR
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Thu, 4 Aug 94 21:03:00 -0500
Message-ID: <12a.3867.905_at_compudata.com>
Date: Thu, 4 Aug 94 21:03:00 -0500
Message-ID: <12a.3867.905_at_compudata.com>
-> Here's the strange part. The cost of the underlying
-> view was 585,039. Creating two indexes, I was able to
-> reduce the cost to 3! Great, right? So I run explain
-> plan on the original SQL statement, and it's cost
-> goes up to 100-something trillion! What's the deal?
Don't use cost based optimization, use rule based. Received on Fri Aug 05 1994 - 04:03:00 CEST