RE: 10g INDEX_RS ? Syntax problem maybe?
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <mohamed.houri@xxxxxxxxx>
- Date: Wed, 5 Dec 2012 10:14:38 -0600
MACD is the alias.
Chris
From: mohamed houri [mailto:mohamed.houri@xxxxxxxxx]
Sent: Wednesday, December 05, 2012 10:13 AM
To: Taylor Christopher - Nashville
Cc: christopherdtaylor1994@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: 10g INDEX_RS ? Syntax problem maybe?
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<http://www.hourim.wordpress.com/>
2012/12/5
<Christopher.Taylor2@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>>
INDEX_RS(MACD, MON_ACCOUNT_CHG_DET_IDX01)
--
Bien Respectueusement
Mohamed Houri
--
//www.freelists.org/webpage/oracle-l
Other related posts:
