Saturday, 27 January 2024

Explain the difference between a primary index and a secondary index in Teradata.

 A primary index is used for the distribution of data and is defined when a table is created. A secondary index, on the other hand, is created after the table has been populated and can be used to enhance query performance by providing alternative access paths to the data.

No comments:

Post a Comment