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

ZDLRA. ra_install.jar. Exception in thread "main" java.sql.SQLException: ORA-28040

If you run the  Oracle Backup module ra_install.jar and got the message: Exception in thread "main" java.sql.SQLException: ORA-2...