RE: 10g INDEX_RS ? Syntax problem maybe?
Date: Wed, 5 Dec 2012 10:14:38 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88567D4792D_at_NADCWPMSGCMS10.hca.corpad.net>
MACD is the alias.
Chris
From: mohamed houri [mailto:mohamed.houri_at_gmail.com]
Sent: Wednesday, December 05, 2012 10:13 AM
To: Taylor Christopher - Nashville
Cc: christopherdtaylor1994_at_gmail.com; oracle-l_at_freelists.org
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_at_parallon.net<mailto: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:14:38 CET