Re: Is this really necessary?

No gain at all in having short field names.

In fact, it will probably drive developers crazy if field names are too short! Personally, i think they should be descriptive (there is a 30 character limit) since it helps your code to be 'self documenting'.  Look on the bright side, typing a few extra characters will hone your keyboard skills!

;-)

M

Daniel Hinojosa <dhinojosa_at_qwest.net> wrote in message news:<3B71FA48.F5A51FD8_at_qwest.net>...
> I have some questions.
>
> Is there a performance gain by keeping field names and table names to a
> minimum of 10 characters or 8 characters? Particularly in an Oracle
> environment?
>
> Is there a logistical advantage (e.g. maintenance, indexing,
> scalability, etc.) by keeping field names and table names to a miniumum
> set of characters?
>
> Is there any advantage gained by naming fields with the convention
> tablename_field (e.g. ACCTCD_ID, ACCTCD_NM, etc), while keeping the
> field name to the minimum amount of characters that I explained above?
>
> Being a java programmer, I love descriptive names. Not too long to
> choke, but just long enough to get the idea across (e.g. firstName,
> lastName, favoriteColor). The above database naming scheme was proposed
> and I am against the idea. I am writing to you for a second opinion.
>
> What do you think?
>
> Thanks in advance.
> Dan
Received on Tue Aug 14 2001 - 11:19:14 CEST