Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: serious performance downgrade on partitioned table.
Jessica
There is a known side-effect of local partitioned indexes that I don't believe is resolved until 8.1.7.3 (someone can correct me on that if they wish). The basic problem is parallel query. For an improvement in performance you will need to use the NOPARALLEL_INDEX hint to serialize access to your local indexes. I'm not sure of the actual mechanics, but it appears that parallel index access is killing the performance of index lookups. Using the hint will get you much closer to where you need to be i.e. almost as quick as "normal" B*Tree indexes. I've experienced this problem myself in 8.1.6 implementations and subsequently read some Metalink threads about it and resolved it in exactly the way I specify (of course until we patch up to 8.1.7.3...)
HTH Adrian Received on Fri Jan 18 2002 - 03:09:13 CST