ok, no ROWID's as ID, what should i use instead? :-)

Hello,

Thanx for all the info about ROWID's. I still got the following questions:
* In many examples, people use NUMBER(38,0) for every ID. Is there a
certain speedup to use such large ID? For example my db has a table of winecolours with maybe 20 rows. Should i still use NUMBER(38,0) as ID because it is faster? NUMBER(38,0) seems to use 128 bits, does a number(?,?) always use that much bits maybe?

• ROWID is like an autonumber in access: it automagically increases when you insert a row in table. But ROWID's can't be used as a foreign key, so i can't use that. Is there something else in oracle that automatically increases and that can be used as index?

Thanx in advance,
Dries Verachtert Received on Fri Jul 28 2000 - 02:38:15 CDT