0 testdata sql drop user test cascade create

Тестовые данные Скрипт 0. test_data. sql -- пользователь drop user test cascade; create user test identified by test; grant connect, resource to test; -- данные для тестового запроса create table test. drop_tbl as select rownum n, 'txt'||rownum txt from dual connect by level <=10000; create index test. i_drop_tbl_id on test. drop_tbl(n); -- статистика begin dbms_stats. gather_table_stats(ownname => 'test', tabname => 'drop_tbl'); end;

Приоритеты при совместном использовании SQL plan Profile baseline SQL patch + + + + + Outline select * from table(dbms_xplan. display(null, ' basic+note')); -- Note + - outline "OL_4 AAY 3 KXC 7 RDDG" used for this statement - SQL patch "patch_4 aay 3 kxc 7 rddg" used for this statement - SQL plan baseline "SQL_PLAN_3 dm 7 hzprspdufe 13 b 857 f" used for this statement - SQL profile "PROF_4 aay 3 kxc 7 rddg" used for this statement - SQL plan baseline "SQL_PLAN_3 dm 7 hzprspdufe 13 b 857 f" used for this statement