Indexes on views

From: Steve Jelfs <s.jelfs_at_nospambtinternet.com>
Date: Thu, 23 Apr 1998 14:04:10 +0100
Message-ID: <353F3C4A.36B9@nospambtinternet.com>

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 Received on Thu Apr 23 1998 - 08:04:10 CDT