Thank you so much for telling me these! I'll definitely try this hint.
If it works, I'll upgrade my database asap. Thanks again!!! -Jessica
billiauk_at_yahoo.co.uk (billiauk) wrote in message news:<dee17a9f.0201180109.200b5e14_at_posting.google.com>...
> 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 - 18:47:24 CST
