InterviewSolution
Saved Bookmarks
| 1. |
Is It Slower If You Access A Record Through Alternative Index As Compared To Primary Index? |
|
Answer» YES it slower because the alternate Key WOULD FIRST locate the PRIMARY Key, which in turn locates the actual record. It requires twice the number of I/Os. Yes it slower because the alternate Key would first locate the primary Key, which in turn locates the actual record. It requires twice the number of I/Os. |
|