Re: Column Questions

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 27 May 2001 18:23:39 -0700
Message-ID: <3B11A89B.148E51FA@exesolutions.com>

"Dr. Mueller" wrote:

> Hello,
>
> I'm seeking advice from experts on a few questions:
>
> 1) Is there a naming convention for indexes and triggers? I've seen a few
> examples for indexes, people use K_ and PK_. Just wondered what you thought
>
> 2) I want to create a DESCRIPTION column, which is a VARCHAR2(256). The
> problem is I want to search it at some point, is it considered an "OK" thing
> to create a non-unique index from this?
>
> That's all.
>
> Thank you.

Starting a primary key index with PK_ or ending it with _PK is pretty standard.

No problem with your VARCHAR2(256) using it as you suggest.

Daniel A. Morgan Received on Sun May 27 2001 - 20:23:39 CDT