Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

As a database administrator for a decision support system (DSS), you are planning a partition index strategy. Which type of index should you create for historical tables?

April 26, 2017Administrator database decision DSS index partition planning strategy support system

0

Posted

As a database administrator for a decision support system (DSS), you are planning a partition index strategy. Which type of index should you create for historical tables?

1 Answer

0

Posted

Local • Evaluate this CREATE TABLE statement: CREATE TABLE record_sales (id NUMBER(8), name VARCHAR2(100), gross_receipts NUMBER(11,2), week_no NUMBER(2)) PARTITION BY RANGE (week_no) (PARTITION P1 VALUES LESS THAN (4) TABLESPACE user_data0, PARTITION P2 VALUES LESS THAN (8) TABLESPACE user_data1); Because of limited data storage, you are concerned with the potential growth of the partitions. You decide to limit the number of extents that can be allocated to each partition. Which command will limit the number of extents to 25 for the P1 partition?