Re: re-indexing per statement or per row?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 6 Apr 2002 15:30:40 +0100
Message-ID: <1018103981.5662.1.nnrp-10.9e984b29@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 - 08:30:40 CST