Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: re-indexing per statement or per row?
Good thought for the day.
Hmmm...
On the direct path loads part I was going from memory on the documentation,
but that aint't proof.
I would have to much around a bit, but I think I would do the following:
Create a dummy table with one index.
trace my session
insert a couple of 1,000 rows using one statement insert into myTable... as
select...from dba_objects;
use tkprof to look at the statistics
do the same thing but with 1,000 sql statements (being lazy I would write sql to generate the sql and run that)
I would think I could deduce something from that.
I'll have to think on it more.
Thanks,
Jim
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:1018103981.5662.1.nnrp-10.9e984b29_at_news.demon.co.uk...
>
> Thought for the day:
>
> If you wanted to PROVE that claim, how would
> you go about building a test case ?
>
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar - UK, April 3rd - 5th
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
>
> Jim Kennedy wrote in message ...
> >per row unless you are doing direct path loads.
> >Jim
> >"Kenny Yu" <kyu_at_biodiscovery.com> wrote in message
> >news:uase5nsnt4u5bd_at_corp.supernews.com...
> >> If a table has indexes, are the indexes updated per statement or per
row
> >for
> >> insert/update operations?
> >> Practically, this affects the choice between bulk sql and putting sql
> >> statements in a loop.
> >>
> >> Kenny
> >>
> >>
> >
> >
>
>
Received on Sat Apr 06 2002 - 10:15:29 CST