Re: Inline view hangs...?

From: <jason.judge_at_virgin.net>
Date: Tue, 12 Dec 2000 16:59:38 GMT
Message-ID: <915lhl$lju$1_at_nnrp1.deja.com>

Found the problem: Oracle 8.0.5 was being very clever and using the wrong index in the inline view when it saw I was referencing one of its columns with a constant outside the inline view.

I didn't think what lies OUTSIDE an inline view affects what happens INSIDE an inline view, but it does!

Sent via Deja.com
http://www.deja.com/ Received on Tue Dec 12 2000 - 17:59:38 CET

This message: [ Message body ]
Next message: Head_Cheese_mmmm: "Help!! How to remove new line Character from spooled output??"
Previous message: jason.judge_at_virgin.net: "Inline view hangs...?"
In reply to: jason.judge_at_virgin.net: "Inline view hangs...?"

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

Original text of this message