Is It Slower If You Access A Record Through Alt Index As Compared To

1.	Is It Slower If You Access A Record Through Alt Index As Compared To Primary Index?
Answer» 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. 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.

Is It Slower If You Access A Record Through Alt Index As Compared To Primary Index?

Answer»

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.

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.