To answer this question, you need to understand the purpose of the AMP parameter BUFNI in a database system.
The AMP parameter BUFNI stands for "Buffer Number of Indexes" and is used to determine the number of index buffers available for random access in a Teradata database system.
Option A) increases the number of Index buffers for random access - This option is correct. By increasing the BUFNI parameter, the number of index buffers is increased, which improves the performance of random access operations.
Option B) increases the amount of virtual storage - This option is incorrect. The BUFNI parameter does not affect the amount of virtual storage in the system. It only affects the number of index buffers.
Option C) increases the number of Data buffers for sequential access - This option is incorrect. The BUFNI parameter is specifically related to index buffers, not data buffers for sequential access.
Option D) All of the above - This option is incorrect. Only option A is correct.
The correct answer is A) increases the number of Index buffers for random access. This option is correct because the BUFNI parameter is used to increase the number of index buffers, improving the performance of random access operations.