精通sql优化

第一章代码

exec dbms_stats.set_table_stats(ownname=>'SCOTT',tabname=>'EMP',numrows=>100000,no_invalidate=>false);
exec dbms_stats.set_index_stats(ownname=>'SCOTT',indname=>'PK_EMP',numrows=>100000,no_invalidate=>false);

select empno,ename,rowid,dbms_rowid.rowid_relative_fno(rowid)||'_'||dbms_rowid.rowid_block_number(rowid)||'_'||dbms_rowid.rowid_row_number(rowid) location from scott.emp;

转载于:https://www.cnblogs.com/oraclinux/p/7582198.html