Re: Indexes and Maxextents
From: Peter Broadfield <GBH3R4BR_at_IBMMAIL.COM>
Date: Fri, 25 Sep 1998 12:28:42 +0100
Message-ID: <6ufsbr$duc5_at_extnews.sunalliance.com>
Date: Fri, 25 Sep 1998 12:28:42 +0100
Message-ID: <6ufsbr$duc5_at_extnews.sunalliance.com>
Stuart,
hello again.
When you are inserting into tables, this is done within a transaction. If
the transaction fails (due to an index filling up) then the whole
transaction will 'ROLLBACK'. So the data will not be in the table for the
current transaction.
Comitting every row would mean only one row would fail but would impact performance.
-- Regards Pete stuco_at_mailcity.com wrote in message <6uebnr$38o$1_at_nnrp1.dejanews.com>...Received on Fri Sep 25 1998 - 13:28:42 CEST
>Question: If I reach the MAXEXTENTS limit on one of my indexes, will the
data
> in my table still get loaded?
>
>If so: Will the index continue to get built after I free the index from
> it's error, OR will my index need to get totally rebuilt??
>
>Very interested in the answer to that one.
>
>Stuart Cowen
>Paladin Consulting - Dallas
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum