equal
deleted
inserted
replaced
428 |
428 |
429 ``plan_table`` should be examined to display result:: |
429 ``plan_table`` should be examined to display result:: |
430 |
430 |
431 select * from table(dbms_xplan.display); |
431 select * from table(dbms_xplan.display); |
432 |
432 |
433 To get actual execution plan run following after executing query:: |
433 Remove statistics:: |
|
434 |
|
435 execute DBMS_STATS.DELETE_SCHEMA_STATS('BOB'); |
|
436 |
|
437 Collect statistics:: |
|
438 |
|
439 execute DBMS_STATS.GATHER_DATABASE_STATS; |
|
440 execute DBMS_STATS.GATHER_SCHEMA_STATS('BOB'); |
|
441 execute DBMS_STATS.GATHER_TABLE_STATS('BOB', 'EMPLOYEE'); |
|
442 |
|
443 Get actual execution plan of query after executing query:: |
434 |
444 |
435 select * from table(dbms_xplan.display_cursor); |
445 select * from table(dbms_xplan.display_cursor); |
436 select * from table(dbms_xplan.display_cursor(format => 'basic')); |
446 select * from table(dbms_xplan.display_cursor(format => 'basic')); |
437 select * from table(dbms_xplan.display_cursor(format => 'typical')); |
447 select * from table(dbms_xplan.display_cursor(format => 'typical')); |
438 select * from table(dbms_xplan.display_cursor(format => 'all')); |
448 select * from table(dbms_xplan.display_cursor(format => 'all')); |