The default value for INITRANS is 1 for tables and ____ for indexes.
A) 0
B) 2
C) 3
D) 4

Name: The default value for INITRANS is 1 for tables and ____ for indexes. A) 0 B) 2 C) 3 D) 4
Brand: Quizplus
Rating: 4.8 (35 reviews)

Question

Quizplus · Accepted Answer

The default value for INITRANS for indexes is 2, while for tables it is 1. This is because indexes are more frequently accessed and modified than tables, hence a higher INITRANS value helps to reduce contention and improve concurrency. A value of 2 is generally considered to be a good starting point for index INITRANS.

The Default Value for INITRANS Is 1 for Tables and ____