Better Plan

Hi All,

Greetings. We have recently migrated all our database to exadata platforms. After exa platform migration have seen Sqls executing faster when using storage smart scans "TABLE ACCESS STORAGE FULL".   Even though the cost of the sql is higher it executes faster but i see developers still going for reducing the cost of the sql by creating more and more indexes on the exa platforms.

one eg is

------------------------------------------------------------------------------------

| Id  | Operation                   | Name            | Rows  | Bytes | Cost (%CPU)|

------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT            |                 |     2 |   206 | 58440   (2)|

|   1 |  VIEW                       | DOC_V           |     2 |   206 | 58440   (2)|

|   2 |   UNION-ALL                 |                 |       |       |            |

|*  3 |    TABLE ACCESS STORAGE FULL| IL_DOC          |     1 |    29 |  2086   (2)|

|*  4 |    TABLE ACCESS STORAGE FULL| IL_DOC_ARCHIVE  |     1 |    38 | 56236   (2)|

------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------

| Id  | Operation                             | Name                       | Rows  | Bytes | Cost (%CPU)|