Can any one help me referring a book for Oracle table partitioning. Oracle 10g complete reference contains the basics but i need elaborate with example.
Thank you
Can any one help me referring a book for Oracle table partitioning. Oracle 10g complete reference contains the basics but i need elaborate with example.
Thank you
I think the discussion in Tom Kyte's book "Effective Oracle by Design" (ch. 3 - Architectural Decisions) does a good job of outlining the concepts as well as the pros and cons of partitioning.
I have "Oracle Database 10g Performance Tuning Tips & Techniques" by Richard Niemiec on my desk. It's a great reference for many Oracle performance issues and has quite a bit of material on partitioning.