Re: Oracle 7 - Indexes ?

From: Virag Saksena <vsaksena_at_us.oracle.com>
Date: 1995/12/01
Message-ID: <49mbcd$q63_at_inet-nntp-gw-1.us.oracle.com>#1/1

Yep,

        The index would be used by that session for querying those rows. Index create is a DDL statement and so any statement which is candidate for using the index will use it after the index has been created. If the table has no rows (as other sessions see it ) then they will return 0 rows but the session which has done the inserts and not committed will actually see the rows using the index. You can actually check this by monitoring the blocks being accessed by your query.

Virag

---

Virag Saksena                                         vsaksena_at_us.oracle.com
Senior Consultant                                     415.506.5087

System Performance Group
Oracle Services

---

In article <49jv32$3ee_at_pheidippides.axion.bt.co.uk> mc_at_pst.bt.co.uk (M C) writes:
>A colleague has brought an interesting question to me :-
>
>He creates a table and inserts a number of rows without committing the
>insert, a index already exists on the table. Does anyone know if the index
>is used by that session when querying without actually doing the commit ?
>
>Rgds Mark
>
Received on Fri Dec 01 1995 - 00:00:00 CET