Help with Optimizer!

	TABLE1		TABLE2 
	LOC_ID		SKU_ID
	SKU_ID		LOC_ID

2) We then created a view that says:

Create view X
(loc_id,sku_id) AS
 (Select LOC_ID,SKU_ID from TABLE1
 UNION ALL
 Select LOC_ID,SKU_ID from TABLE2)

3) We then created an index on LOC_ID on table1 and table2.

 When we select from view X where loc_id in (5,8,10,12) we get full table scans.

 When we recreate TABLE2 the same as TABLE1 and run the above query we get index range scans.

 Why are we not getting index range scans when the column order is not the same?