Performance impact with adding columns to table

From: freddy loo <freddy.loo_at_accenture.com>
Date: 26 Jun 2002 04:10:04 -0700
Message-ID: <c3470bcf.0206260310.a3db7f0_at_posting.google.com>


Hi,

I am fairly new to Oracle and would like to seek advice on a couple of stuff.
1. Will performance of a table be impacted if i add a column to the table using the alter table command. Will performance be better if i were to drop and recreate the table. And of course, why?

2. Where can I find some good guide for performance tuning to a Oracle database and also the best practices for database?

Thanks a lot.
Fred Received on Wed Jun 26 2002 - 13:10:04 CEST

Original text of this message