Re: Utilisation ratio for an index

From: <stevedhoward_at_gmail.com>
Date: 7 Apr 2006 08:08:59 -0700
Message-ID: <1144422538.975769.138200@u72g2000cwu.googlegroups.com>

That's really interesting. Since if I select against someone elses table, it will use their index, I wonder what the idea was behind restricting it to the owner?

SQL> connect system
Enter password:
Connected.
SQL> set autotrace on explain
SQL> select /*+ index(t0406 t0406_i) */ * from rep.t0406 where c = 5000;

         C

---

      5000

Execution Plan

---

Plan hash value: 3751500940

---

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time

   |

---

| 0 | SELECT STATEMENT | | 1 | 13 | 1 (0)| 00:00:01 |
|* 1 | INDEX RANGE SCAN| T0406_I | 1 | 13 | 1 (0)| 00:00:01 |

---

Predicate Information (identified by operation id):

---

   1 - access("C"=5000)

Note

---

• dynamic sampling used for this statement

SQL> Thanks!

Steve Received on Fri Apr 07 2006 - 10:08:59 CDT