Menu
What effect does a field name length has on the performance of a database? Is it negligible? Should I go with long descriptive names?
516
As per my knowledge .. it will not effect the database performace.. because varchar2 will not allocate the whole 1000 .. it will allocate the space according to the stored data. Hi, It will not affect the performance of the database.
Field names in the same table must be unique; for instance, you can't have two columns with the name ObjectID. Field names must also start with a letter and cannot contain spaces or reserved words.
When the Text driver is used, the maximum column name is 64 characters, and longer names are truncated.
Definition and Usage The LENGTH() function returns the length of a string (in bytes).
The database server converts field names into an internal representation. So the only time the name's length affects performance is when the server parses your SQL statements. The performance impact of this is negligible for typical applications.
133
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
