장기기억장치

/*set pagesize 0;select * from print_table('select * from test.emp where rownum 0 ) loop for i in 1 .. l_colCnt loop if ( l_descTbl(i).col_type not in ( 113 ) ) then dbms_sql.column_value ( l_theCursor, i, l_columnValue ); pipe row( printTblScalar( l_descTbl(i).col_name, ..

// cluster_by_rowid // clustering factor 가 낮을 때 사용하면 빠른 결과 도출select /*+ ordered use_nl(b) rowid(b) */ b.*from (select /*+ index(emp emp_X1) no_merge */ rowid rid from emp where ename = 'SCOTT' order by rowid) a, emp bwhere b.rowid = a.rid ;-- after 12cselect /*+ cluster_by_rowid(e) index(e emp_x1) */ * from emp e where ename = 'SCOTT' ;

보호되어 있는 글입니다.