Re: Index not being used

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Tue, 20 Apr 2010 14:51:46 +0200
Message-ID: <l2ocd8f74561004200551j2d90ea48t750d1e1ee37fb551_at_mail.gmail.com>

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_at_gmail.com> 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 |
†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Apr 20 2010 - 07:51:46 CDT