InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Can An Index Become Larger Than The Table To Which It Belongs? |
|
Answer» Yes. This is possible, for example, if the index is created on a little USED field (that is, a field filled with too little data), but the primary key requires too much memory. The key INFORMATION is stored in a reduced form at index LEVEL in the B* tree of the table, while the secondary index must store each COMPLETE primary key. Yes. This is possible, for example, if the index is created on a little used field (that is, a field filled with too little data), but the primary key requires too much memory. The key information is stored in a reduced form at index level in the B* tree of the table, while the secondary index must store each complete primary key. |
|