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.



Discussion

No Comment Found