Re: Query Optimizer does not ignore constant condition?

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 24 Aug 2003 10:59:35 -0700
Message-ID: <3722db.0308240959.5f0ca268_at_posting.google.com>

Post the execution plans for both cases, and then we'll be able to see what's going on. Important data include Oracle version, optimizer_mode, tables analyzed recently or not, ...

Daniel Received on Sun Aug 24 2003 - 19:59:35 CEST

This message: [ Message body ]
Next message: tomek: "Oracle9iAS + JBuilder9"
Previous message: Daniel Roy: "Re: materialized view. help..."
Maybe in reply to: hemal: "Query Optimizer does not ignore constant condition?"
Next in thread: Ana C. Dent: "Re: Oracle9iAS + JBuilder9"
Reply: hemal: "Re: Query Optimizer does not ignore constant condition?"

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

Original text of this message