Question: what is the difference between index and partition in oracle?
Answer: Database partitioning — Manage Database in marvellous manner. Database Indexing — Increase Speed and Efficiency of Database. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity.