Re: Short_names vs long_names objects...

From: Lisa Spory <lspory_at_yahoo.com>
Date: Thu, 20 May 2004 10:44:59 -0700 (PDT)
Message-ID: <20040520174459.96038.qmail@web21405.mail.yahoo.com>

Jose,  

I like to keep table names less than 15 characters (20 max) so that objects you name related to that table (e.g. indexes / constraints) can easily inherit the table name.  

Regards,  

Lisa
Jose Luis Delgado <joseluis_delgado_at_yahoo.com> wrote: Hi to all...

I'd like to know if any of you have docs for naming objects, pros and cons...

Some guys are saying that Oracle recommend the use of objects with less than 30 chars (24 to be accurates) because of performance reasons.

That objects names should be in singular, and not much longers.

Any points or docs?

TIA
JL

---

Do you Yahoo!?
Yahoo! Domains – Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

                

---

Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu May 20 2004 - 12:42:02 CDT