Generating Sequences To Use as Basis of 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 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 Wed Nov 07 2001 - 21:47:51 CST