Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_discover.com>, Sent by: "oracle-l" <oracle-l_at_freelists.org> oracle-l-bounce_at_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
Received on Mon Oct 29 2007 - 17:05:06 CDT
![]() |
![]() |