Re: Full table scan despite appropriate indexes

From: <aravind.kanda_at_gmail.com>
Date: 8 Feb 2007 07:29:25 -0800
Message-ID: <1170948565.229859.135710@v33g2000cwv.googlegroups.com>

Here is the output of dbms_xplan.display:

PLAN_TABLE_OUTPUT

---

| Id  | Operation                     |  Name                    |

Rows | Bytes | Cost |

---

| 0 | SELECT STATEMENT | |
1 | 14 | 6939 |
| 1 | SORT AGGREGATE | |

1 |    14 |       |


|   2 |   HASH JOIN                   |                          |

8292K|   110M|  6939 |


|   3 |    TABLE ACCESS BY INDEX ROWID| TDATE                    |

30 |   270 |     2 |


|   4 |     INDEX RANGE SCAN          | IDX_TDATE_YEAR_MONTH_CT  |

30 |       |     1 |


|   5 |    TABLE ACCESS FULL          | TCOVERAGES_SUMMARY       |

11M| 57M| 6911 |

---

Note: cpu costing is off, TOAD_PLAN_TABLE' is old version Received on Thu Feb 08 2007 - 09:29:25 CST