Global/Local Index

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