InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are The Things To Be Considered While Creating Secondary Index? |
|
Answer» Creating a SECONDARY index causes TERADATA to build a sub-table to contain its index rows, thus adding another set of rows that requires updating each time a table row is inserted, deleted, or UPDATED. Secondary index sub-tables are also duplicated WHENEVER a table is DEFINED with FALLBACK, so the maintenance overhead is effectively doubled. Creating a secondary index causes Teradata to build a sub-table to contain its index rows, thus adding another set of rows that requires updating each time a table row is inserted, deleted, or updated. Secondary index sub-tables are also duplicated whenever a table is defined with FALLBACK, so the maintenance overhead is effectively doubled. |
|