Re: convert dds to ddl

Not sure about this:
<snip>
I will create new SQL indexes prior to re-creating my old logicals.
what else can/should I do to my logicals?
</snip>
Were you thinking about recreating your logicals in DDS, but first create
indexes? I do not see a reason to use DDS to recreate your logicals.

Some indexes you may not have but which may come in handy ...
If you have select/omit logicals (which you can do just fine in DDS on
6.1) like this
CREATE INDEX ROB/gqcyl1
ON ROB/GQCY
(MUVALUE)
WHERE RECID='A'

Then you may also want an index like this first
CREATE INDEX ROB/gqcyl2
ON ROB/GQCY
(recid, MUVALUE)

I think this will help performance of queries over the base table which do
something like
SELECT ...
FROM GQCY
WHERE RECID='A'...
And I think you want those created first.


Rob Berendt