From: jason.judge@virgin.net
Newsgroups: comp.databases.oracle.tools
Subject: Re: Inline view hangs...?
Date: Tue, 12 Dec 2000 16:59:38 GMT
Organization: Deja.com
Lines: 12
Message-ID: <915lhl$lju$1@nnrp1.deja.com>
References: <915g5a$ggl$1@nnrp1.deja.com>
NNTP-Posting-Host: 195.188.219.99
X-Article-Creation-Date: Tue Dec 12 16:59:38 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0; c_commuk)
X-Http-Proxy: 1.0 WEBSWEEPER, 1.0 x70.deja.com:80 (Squid/1.1.22) for client 195.188.219.99
X-MyDeja-Info: XMYDJUIDjasonjudge


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!

JJ


Sent via Deja.com
http://www.deja.com/