| Reg. Performance on Table alter [message #145890] |
Mon, 07 November 2005 08:27  |
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
|
Senior Member |
|
|
Hi All,
We have a requirement .we have to add some fields to the existing project.
Here there are two methods:
1. we can create one more table for these fields.
2.we can add these extra fields to the existing table.
On the basis performance which will be better.
Thanks
Regds
Dinesh
|
|
|
|
| Re: Reg. Performance on Table alter [message #145930 is a reply to message #145890] |
Mon, 07 November 2005 14:42  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
This should not be a decision based on performance. It is a decision of design; if these columns belong in your existing table, add them. (after all, even if performance is a point, it is a one-time only action)
hth
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
