RE: analyze after adding a nullable column

Alvaro,

No, currently the new columns is not used anywhere . The number of rows in
the tables is in hundred of millions.
The new columns is char(1) and the row length will increase only marginally
(all tables a pretty wide)

thank you

Gene Gurevich



                                                                           
             "Alvaro Jose                                                  
             Fernandez"                                                    
             <alvaro.fernandez                                          To 
             @sivsa.com>               <genegurevich@xxxxxxxxxxxx>,        
             Sent by:                  "oracle-l" <oracle-l@xxxxxxxxxxxxx> 
             oracle-l-bounce@f                                          cc 
             reelists.org                                                  
                                                                   Subject 
                                       RE: analyze after adding a nullable 
             10/04/2007 03:10          column                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             alvaro.fernandez@                                             
                 sivsa.com                                                 
                                                                           
                                                                           




Hi Gene,

It depends on the datatype and length, if you add a CHAR (not an
VARCHAR) or some other fixed length types (size), and depending also of
the number of rows in the table, the plans would be need to be
reevaluated, if the average row length got significantly higher (mainly
for recosting FTS)

I'm assuming you are not yet using the new column as filter predicate in
the queries, am I right?

alvaro

Hi  everybody:

Do I need to reanalyze the table if I add a nullable column and do not
populate it with values (oracle 10.2.0.3)?

thank you

Gene Gurevich


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l






--
http://www.freelists.org/webpage/oracle-l

Other related posts: