Index Optimization Series 15-- Combinatorial query and in-related Optimization
Drop table t purge
Create table t as select * from dba_objects
Update t set object_id=rownum
Create index idx_id_type on t (object_id,object_type)
UPDATE t SET OBJECT_ID=20 WHERE ROWNUM= 20 AND OBJECT_ID=20 AND "OBJECT_TYPE" = 'TABLE' AND "OBJECT_ID"
