Re: Naming convention?

From: J.P. <jp_boileau_at_yahoo.com>
Date: 10 Apr 2002 12:27:53 -0700
Message-ID: <7e388bc3.0204101127.4e52a32@posting.google.com>

Percival,

One reason to keep a naming convention on indexes is this one:

If you ever need to put hints in your SQL code to force the use of a certain index, a name with significance is greatly appreciated.

For instance:

SELECT /*+ INDEX(CUSTOMERS CUSTOMERS_CUSTID) */    CUST_NAME
FROM
   CUSTOMERS
WHERE
   CUST_ID = :MyCustID

Now that is a LOT more significant than:

SELECT /*+ INDEX(CUSTOMERS CUSTOMER_INDEX01) */    CUST_NAME
FROM
   CUSTOMERS
WHERE
   CUST_ID = :MyCustID

ESPECIALLY when doing SQL Tuning! :)

"Percival Boqais" <pb_at_microsoft.com> wrote in message news:<gJOs8.6679$Ne5.1333877869_at_newssvr15.news.prodigy.com>...
> Looking through a few Oracle 8/8i databases with TOAD, I noticed different
> standards for index, sequence and column naming. Is there an Oracle
> standard for naming these objects? I would like to think there is. As I
> believe, an index is in a global namespace, it's not relative to a table for
> example.
>
> ~ PB
Received on Wed Apr 10 2002 - 14:27:53 CDT