| |||||
|
Is it slower if you access a record through ALT More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) Is it slower if you access a record through ALT INDEX as compared to Primary INDEX ? Yes. Why ? Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os. (Continued on next question...)
Other Job Interview Questions
|
||||