Re: D2K default index creation
From: dan macdonald <dmacdonald_at_mailhost.wlc.com>
Date: 1997/09/04
Message-ID: <340e2c85.0_at_news.wlc.com>#1/1
Date: 1997/09/04
Message-ID: <340e2c85.0_at_news.wlc.com>#1/1
if you check the DDL that gets created, you'll find that primary keys are created with the 'USING INDEX' option. so indexes are created for them 'autmatically'.
dan
In article <340C2000.2C39_at_ed.ac.uk>, Natasha.Ritchie_at_ed.ac.uk says...
>
>Within Case Dictionary 5.0/1 one had the means to generate default
>indexes for primary and foreign keys (see p.5-175 Case Dict ref guide) -
>we're trying to do the same with D2K but can only find the means to
>default foreign key indexes. Have contacted the Oracle helpdesk folk who
>have proved totally unhelpful. Help! please would somebody out there
>point us in the right direction?
>
>Many thanks.
Received on Thu Sep 04 1997 - 00:00:00 CEST