The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question, subrata.
Asked: May 28, 2023 - 4:29 am UTC
Last updated: June 02, 2023 - 3:13 am UTC
Version: 19c
Viewed 10K+ times! This question is
SQL> set autotrace traceonly explain SQL> select * 2 from t 3 where owner = 'SYS'; Execution Plan ---------------------------------------------------------- Plan hash value: 1601196873 -------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 2290 | 315K| 474 (1)| 00:00:01 | |* 1 | TABLE ACCESS FULL| T | 2290 | 315K| 474 (1)| 00:00:01 | -------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("OWNER"='SYS') SQL> SQL> select /*+ opt_estimate(@"SEL$1", TABLE, "T"@"SEL$1", SCALE_ROWS=2) */ * 2 from t 3 where owner = 'SYS'; Execution Plan ---------------------------------------------------------- Plan hash value: 1601196873 -------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 4579 | 630K| 474 (1)| 00:00:01 | |* 1 | TABLE ACCESS FULL| T | 4579 | 630K| 474 (1)| 00:00:01 | -------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("OWNER"='SYS')
Get all the information about database performance in the Database Performance guide.