Re: INDEX RANGE SCAN not used when View is used

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Wed, 17 Mar 2004 10:12:48 -0500
Message-ID: <eWZ5c.6726$Eb6.220638@news20.bellglobal.com>

"mcrn" <readyjapan_at_hotmail.com> a écrit dans le message de news:a727f79a.0403161508.660d0f5d_at_posting.google.com...

[snip]

> However, there are two restricions that must be imposed to the
> solution:
> 1) I am not allowed to use db hints.
> 2) I cannot change the original sql query.
>

Silly, but you did ANALYZE those tables, did you ? Received on Wed Mar 17 2004 - 09:12:48 CST

This message: [ Message body ]
Next message: Ed Stevens: "Re: where is this GLOBAL_NAME value coming from?"
Previous message: Brian Peasland: "Re: Problems installing Oracle9i on Fedora with 256 RAM"
In reply to: mcrn: "INDEX RANGE SCAN not used when View is used"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US