Saturday, May 22, 2004
Should any developers read this - a little note on how best to use SQL.
1. Please use the appropriate command. It is not necessary to drop and recreate a table to add a column.
2. If you were going to drop and recreate a table consider that Oracle will think that the new table is very small until you collect stats, so please do collect stats or at least allow the poor sap in charge of the program to catch the ddl and add a stats collection task in.
3. don't update a row at a time in a loop.
that is all
0 Comments
1. Please use the appropriate command. It is not necessary to drop and recreate a table to add a column.
2. If you were going to drop and recreate a table consider that Oracle will think that the new table is very small until you collect stats, so please do collect stats or at least allow the poor sap in charge of the program to catch the ddl and add a stats collection task in.
3. don't update a row at a time in a loop.
that is all
0 Comments:
Post a Comment
