Generating Sequences as Basis of an Index

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?

Thanks. Received on Thu Nov 08 2001 - 06:27:59 CST