STATEMENT_ID | TIMESTAMP | REMARKS | OPERATION | OPTIONS | OBJECT_NODE | OBJECT_OWNER | OBJECT_NAME | OBJECT_INSTANCE | OBJECT_TYPE | OPTIMIZER | SEARCH_COLUMNS | ID | PARENT_ID | POSITION | COST | CARDINALITY | BYTES | OTHER_TAG | PARTITION_START | PARTITION_STOP | PARTITION_ID | OTHER | DISTRIBUTION |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MINE | 14-APR-09 | HASH JOIN | 1 | 0 | 1 | 471158 | 966384 | 114999696 | |||||||||||||||
MINE | 14-APR-09 | TABLE ACCESS | FULL | MARQUEE | BIS_PRODUCT | 3 | ANALYZED | 2 | 1 | 1 | 3 | 1726 | 12082 | ||||||||||
MINE | 14-APR-09 | HASH JOIN | 3 | 1 | 2 | 471081 | 966384 | 108235008 | |||||||||||||||
MINE | 14-APR-09 | TABLE ACCESS | BY INDEX ROWID | MARQUEE_OWNER | BILLING_REPORT_DATE | 1 | ANALYZED | 4 | 3 | 1 | 2 | 7 | 56 | ||||||||||
MINE | 14-APR-09 | INDEX | RANGE SCAN | MARQUEE_OWNER | BILLING_REPORT_DATE_IE1 | NON-UNIQUE | ANALYZED | 2 | 5 | 4 | 1 | 1 | 1 | ||||||||||
MINE | 14-APR-09 | TABLE ACCESS | FULL | MARQUEE_OWNER | MONTHLY_BILL_REVENUE_HIST | 2 | ANALYZED | 6 | 3 | 2 | 468831 | 94881357 | 9867661128 | ||||||||||
MINE | 14-APR-09 | SELECT STATEMENT | CHOOSE | 0 | 471158 | 471158 | 966384 | 114999696 |