Why does Optimizer not pick up indexes?

[slimdave]

maybe ur tables have grown bigger and fragmented. You may consider reorganizing it. Consider partitioning and run parallel query on all partitions

i) Fragmented how?
ii) Why partition?
iii) Parallelism would speed the result, but use more resources ... seems rather like a brute force method if all else fails.