Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Apr 2003 @ 22:03:19 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: How to Disconnect Users During Loads
From:   Walter, Todd A

Fixed in 4.1.0. Create Index requires a read lock on the table as of 4.1. And only a brief lock on the dictionary at the end.

Of course if you drop the index during the load, then queries running during that time that require the index will have unpredictable response times.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016