What must you do to an application for it to take advantage of partitioning?

Question

Options

• Arecompile it
• Brewrite its SQL queries
• Crelink
• Drework the applications schema
• Enothing; it is transparent

• A
  2% (1)
• B
  15% (6)
• C
  7% (3)
• D
  2% (1)
• E
  73% (30)

Explanation

https://docs.oracle.com/cd/B19306_01/server.102/b14220/partconc.htm Introduction to Partitioning Partitioning addresses key issues in supporting very large tables and indexes by letting you decompose them into smaller and more manageable pieces called partitions. SQL queries and DML statements do not need to be modified in order to access partitioned tables. However, after partitions are defined, DDL statements can access and manipulate individuals partitions rather than entire tables or indexes. This is how partitioning can simplify the manageability of large database objects. Also, partitioning is entirely transparent to applications. Each partition of a table or index must have the same logical attributes, such as column names, datatypes, and constraints, but each partition can have separate physical attributes such as pctfree, pctused, and tablespaces. Partitioning is useful for many different types of applications, particularly applications that manage large volumes of data. OLTP systems often benefit from improvements in manageability and availability, while data warehousing systems benefit from performance and manageability.

No community discussion yet for this question.