Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to automatically generate foreign key index for Oracle

352 views
Skip to first unread message

hesterzhang

unread,
Apr 28, 2005, 3:06:48 PM4/28/05
to
Hi. I'm looking for an option on PD 9.5 to automatically
generate foreign key index for Oracle 9i/10g. Is there such
an option/checkbox on PD?

Thank you very much
-Hester

Mike Nicewarner

unread,
Apr 30, 2005, 5:01:40 PM4/30/05
to
You can create indexes to support foreign keys in PD.
Click on Tools, Rebuild, Indexes.
In the dialog box, select to rebuild FK indexes.

--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike[at]datamodel[dot]org (can you figure what to change?)
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

hesterzhang

unread,
May 5, 2005, 3:35:15 PM5/5/05
to
Thank you very much Mike. It works

Mike Nicewarner

unread,
May 6, 2005, 11:17:58 PM5/6/05
to
Look here "C:\Program Files\Sybase\PowerDesigner 11\Printable Docs"
The doc is "Advanced.pdf".
0 new messages