Re: 10g INDEX_RS ? Syntax problem maybe?
From: mohamed houri <mohamed.houri_at_gmail.com>
Date: Wed, 5 Dec 2012 17:13:04 +0100
Message-ID: <CAJu8R6guADNR3PPmUqAnxUAMxgqD4bMd5A+iijt9mcbJsA-tbw_at_mail.gmail.com>
Just for curiosity are you using an alias for your table MACD? SQL> explain plan for insert into t select /*+ index(emp emp_pk) */ * from emp e;
Explained.
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
Date: Wed, 5 Dec 2012 17:13:04 +0100
Message-ID: <CAJu8R6guADNR3PPmUqAnxUAMxgqD4bMd5A+iijt9mcbJsA-tbw_at_mail.gmail.com>
Just for curiosity are you using an alias for your table MACD? SQL> explain plan for insert into t select /*+ index(emp emp_pk) */ * from emp e;
Explained.
SQL> select * from table(dbms_xplan.display);
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
| 0 | INSERT STATEMENT | | 15 | 570 | 5 (0)| 00:00:01 | | 1 | TABLE ACCESS FULL| EMP | 15 | 570 | 5 (0)| 00:00:01 | --------------------------------------------------------------------------
SQL> explain plan for insert into t select /*+ index(e emp_pk) */ * from
emp e;
Explained.
SQL> select * from table(dbms_xplan.display);
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------------------- | 0 | INSERT STATEMENT | | 15 | 570 | 3 (0)| 00:00:01 | | 1 | TABLE ACCESS BY INDEX ROWID| EMP | 15 | 570 | 3 (0)| 00:00:01 | | 2 | INDEX FULL SCAN | EMP_PK | 15 | | 1 (0)|00:00:01 |
Mohamed Houri
www.hourim.wordpress.com
2012/12/5 <Christopher.Taylor2_at_parallon.net>
> INDEX_RS(MACD, MON_ACCOUNT_CHG_DET_IDX01)
>
>
-- Bien Respectueusement Mohamed Houri -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 05 2012 - 17:13:04 CET