Re: Indexes on views

From: <bialik_at_wis.weizmann.ac.il>
Date: Thu, 23 Apr 1998 13:52:58 -0600
Message-ID: <6ho2mb$j0$1@nnrp1.dejanews.com>

Hi.

I got similar problem when joining 9-10 tables. In my case hint /*+ INDEX ( <table_name> <index_name> ) */ solved the problem.

Good luck. Michael.

In article <353F3C4A.36B9_at_nospambtinternet.com>, Steve Jelfs <s.jelfs_at_nospambtinternet.com> wrote:
>
> I have a view on several (14) tables. All the tables are the same (they
> have the same columns etc, it's just they are organised into weeks) and
> they have an index which when I query the view I make sure I hit.
>
> However, when looking at an explain plan the index is hit on say 12 of
> the 14 tables but a full table scan is done on the other 2!
>
> I am using 7.3.4 and wondered whether anyone out there could come up
> with a possible reason
>
> Thanks
>
> Sj
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 23 1998 - 14:52:58 CDT