Re: sppeding up partition views

From: A.E.Vervaeke <alanv_at_opustel.com>
Date: 1998/02/19
Message-ID: <6chlc5$jqq@news9.noc.netcom.net>#1/1

Thomas, it depends on what you are searching for. If you are using a partition view of 60 tables, are you narrowing your search based upon the partition key?? Are there other columns that you are searching on that could be indexed ? If your partition view is set up to be partitioned by , lets say, date and you do not include date in the where clause, then looking at the explain plan will show you that you are searching all 60 tables. Have you done an explain plan ? In 7.3.4 you can set up the AUTOTRACE role and use it thru SQL*plus.

Alan V.

Thomas Hilke wrote in message <34EC2AE9.E482B64E_at_dlh.de>...
>hi.
>
>Im trying to speed up the anser-time of a partition-view. I#m working on
>a hp ux 10.10 with Oracle V 7.3.3.4.
>
>The partition view contains of 60 tables with 1.000.000 rows per table.
>
>The answer time greater than 2000 ( with "set timing on").
>
>Have anybody tips for me ?
>
>
Received on Thu Feb 19 1998 - 00:00:00 CST