Re: Generating Sequences as Basis of an Index

stanky wrote:
>
> Do you normally create sequences as the basis of your indexes or do you just
> use the values of the specific column. For instance, let's say you have
> some data in a file...let's call it Account Data. Within this data you have
> data that you call Account Name. It uniquely identifies the other data in
> each record of the file. If you're planning to load this data to a table,
> is it better to
> generate a sequence to build the index upon or just use the data values of
> Account Name.
>
> I'm just curious as to whether a numeric column like sequence yields better
> indexing results than a character based column. By the way, what is the
> data type for a default sequence?

Hello,

I would create a new column wich is filled by an sequence and use this column
as the primary key. When you reference on this column you can change your
account-name without changing all referencig foreign-keys.

Regards, Stephan Received on Fri Nov 09 2001 - 02:30:38 CST