Re: Index not being used
- From: Kumar Madduri <ksmadduri@xxxxxxxxx>
- To: oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 20 Apr 2010 09:26:59 -0700
SQL> explain plan
2 for
3 SELECT /*+ INDEX(PA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_ITEMS_N3) */
*
4 FROM pa_expenditure_items_all
5 WHERE system_linkage_function = 'VI';
Explained.
SQL> SELECT *
2 FROM TABLE(DBMS_XPLAN.DISPLAY);
Plan hash value: 3707576984
--------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows |
Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9241K|
2414M| 2699K (2)| 08:59:52 |
|* 1 | TABLE ACCESS BY INDEX ROWID| PA_EXPENDITURE_ITEMS_ALL | 9241K|
2414M| 2699K (2)| 08:59:52 |
| 2 | INDEX FULL SCAN | PA_EXPENDITURE_ITEMS_N3 |
36M| | 92416 (2)| 00:18:29 |
--------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("SYSTEM_LINKAGE_FUNCTION"='VI')
14 rows selected.
SQL>
On Tue, Apr 20, 2010 at 5:51 AM, Martin Berger <martin.a.berger@xxxxxxxxx>wrote:
> Can you please provide an execution Plan of the hinted statement on
> Database 1?
>
> regards,
> Martin
>
>
Other related posts:
