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

How to copy a file from ASM at host one to ASM at host twho ?

Because of archivelog gap there was the need to copy archive log file from primary Exadata   to standby Exadata. Primary Exadata archiv...