What is table partitioning and what are its advantages and disadvantages? Also, what is bulk collection? What are...
Oracle partitioning is used as a divide-and-conquer approach to make it easier to maintain very large objects (tables and indexes) and to speed up certain types of SQL queries. See my notes here.
Dig Deeper on Oracle database design and architecture
Related Q&A from Don Burleson
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
In Oracle 9i, is there a way to identify the specific row being locked in a particular table? I have seen much code that identifies the object being ... Continue Reading
I am having a problem viewing the queries in v$sqlarea. I have a procedure (p1) with lots of insert, select, update and delete statements. I am ... Continue Reading