What Is The Secondary Index?

1.	What Is The Secondary Index?
Answer» There is an INDEX created by default for the PRIMARY KEY of the table and that is called Primary Index. If you create, any other index that is called Secondary Index for that table. Secondary INDEXES are created to improve the PERFORMANCE of SELECT statements. There is an Index created by default for the Primary Key of the table and that is called Primary Index. If you create, any other index that is called Secondary Index for that table. Secondary Indexes are created to improve the performance of SELECT statements.

Answer»

There is an INDEX created by default for the PRIMARY KEY of the table and that is called Primary Index. If you create, any other index that is called Secondary Index for that table. Secondary INDEXES are created to improve the PERFORMANCE of SELECT statements.

There is an Index created by default for the Primary Key of the table and that is called Primary Index. If you create, any other index that is called Secondary Index for that table. Secondary Indexes are created to improve the performance of SELECT statements.

Discussion

No Comment Found

Related InterviewSolutions

How Do We Describe Start –of-selection And End-of-selection?
When It’s The Right Time To Utilize The Command Get Cursor In Interactive Lists?
What Is The Significance Of A Stacked List?
What Are The Ways Of Creating Tables?
What Is The Difference Between Collect And Sum?
What Is Refreshing In Internal Table?
How Many Types Of Standard Internal Tables?
Explain Check Table And Value Table?
What Are Text Elements?
What Is The Transaction Code Sm 31?