Re: migrating - index question
From: Sybrand Bakker <Sybrand.Bakker_at_Bentley.nl>
Date: 1995/10/11
Message-ID: <45ftq9$rhp_at_sun630.bentley.com>#1/1
Date: 1995/10/11
Message-ID: <45ftq9$rhp_at_sun630.bentley.com>#1/1
Tony,
Regarding primary and unique keys:
You're right in assuming this should be handled by using constraints.
Look into the manual on p. 4-126 and following. The 'using index' clause
is also available for the primary key constraint.
Oracle already didn't create descending indexes in v6. Descending sort
can still be accomplished by 'Order by <column_name> DESC'.
Sybrand Bakker
Senior IS Analyst
Bentley Systems Europe
Hoofddorp
The Netherlands
#include <std_dclaimer.h> Received on Wed Oct 11 1995 - 00:00:00 CET