Re: Global/Local Index

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 15 Dec 1999 17:55:38 +0800
Message-ID: <3857659A.4F4E@yahoo.com>

Paul Bennett wrote:
>
> I have an issue where when I was joining a table where one side was
> stored in a local index and one in a global index, the optimizer would
> choose a full table scan instead of using the available index. When I
> changed this so that both index where local, the optimizer used the
> index. Why is this?
>
> -- Paul

Possibly because the chances of partition elimination were higher - once you have eliminated one or more partitions, an index read may look more attractive...

Cheers
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 15 1999 - 03:55:38 CST