Re: Column Questions

From: Spencer <spencerp_at_swbell.net>
Date: Sun, 27 May 2001 16:02:51 -0500
Message-ID: <1WdQ6.419$My3.102546@nnrp3.sbc.net>

"Dr. Mueller" <nospam_at_nospam.com> wrote in message news:oqdQ6.2710$kh4.236464_at_bgtnsc04-news.ops.worldnet.att.net...
> 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
>

there are quite a few naming conventions in common use. we typically use a unique 6 character "table identifier" as the first part of the table name (e.g. TVX010_SUBSCRIBER and the use the table id in the names of constraints, indexes and triggers on the table... e.g. TVX010_PK, TVX010_IX1, TR_TVX010. the table identifier is not used in the view name (e.g. SUBSCRIBER)

> 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?
>

an index on the DESCRIPTION column may speed up some queries. if you mean by "searching", runnint a query using a construct such as WHERE DESCRIPTION LIKE '%somestring%', then, no, Oracle will not use an index on DESCRIPTION.

> That's all.
>
> Thank you.
>
Received on Sun May 27 2001 - 16:02:51 CDT