Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> non-unique index enforcing pk
Are there performance caveats on index access when enforcing a pk with a non-unique index?
I see that a query that specifies a single pk value against such a table gets an INDEX RANGE SCAN rather than an INDEX UNIQUE SCAN. But I'm wondering if it is actually more expensive in this case..? Received on Wed Feb 08 2006 - 18:31:23 CST