Re: Index not being used
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: ksmadduri@xxxxxxxxx
- Date: Tue, 20 Apr 2010 14:52:25 +0200
Can you please provide an execution Plan of the hinted statement on Database 1?
regards,
Martin
On Tue, Apr 20, 2010 at 11:49, Kumar Madduri <ksmadduri@xxxxxxxxx> wrote:
> Hi
> Database 1 is on 11.1.0.7.2
...
> | Id | Operation | Name | Rows | Bytes | Cost
> (%CPU)| Time |
...
> --------------------------------------------------------------------------------
> | 0 | SELECT STATEMENT | | 47861 | 12M| 679K
> (3)| 02:15:51 |
> =====
> Database 2 is on 11.1.0.7.1 and
...
> Plan hash value: 1598013654
> | Id | Operation | Name | Rows |
> Bytes | Cost (%CPU)| Time |
> --------------------------------------------------------------------------------
> | 0 | SELECT STATEMENT | | 13 |
> 3588 | 7 (0)| 00:00:01 |
Other related posts: