I have 121047 recs in a table and have partitioned it on the distinct dept ids (total 13) 'Deptnnn'. I then created a local index on the partition and analyzed the table. Now when I do a select from the table with 'dept=201' (one of the dept's) it shows a full table scan, why does it not show it accessing the 'Dept201' partition?. What is being done wrong here? Some good tips on partitioning would help