Exadata: Is CREATE INDEX smart-scanable ?

Wednesday, March 5, 2014

Is CREATE INDEX smart-scanable ?

The answer is YES !
Look:

set timing on

CREATE UNIQUE INDEX "DW_STG"."UK#CALLS_00" ON "DW_STG"."CALLS_00" ("CALL_ID") PCTFREE 0 INITRANS 24 MAXTRANS 255 PARALLEL 64 ;

You can see the column "Cell Offloading" = 95%

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)