Best Practice for adding columns to a Table in Oracle database

834 views Asked by At

I came across a scenario where there is a column need to be added in a table. What is the Industries best practices to add a column to the existing table in Production System.

  1. By default at the end
  2. At appropriate position
  3. Before the Audit fields of the table

Our data modeler has added the column and chose the default options. Is there any performance hit if the added column is used frequently.

What is the efforts to develop the script that always add the column before the audit fields as a standard?

Any help will appreciated.

1

There are 1 answers

1
Martina On

It is not possible in Oracle to decide position of the new column. (well, unless you drop and recreate new table). Note, that order of columns is not related to performance issues.