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.

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-l
Received on Wed Dec 05 2012 - 17:13:04 CET

Original text of this message