Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
Table indexes
System
I want that some indexes are also created for tables during database deployment using DataDeploy 5.6.
Is this possible, and if so what is the appropriate way?
Thanx.
Find more posts tagged with
Comments
Migrateduser
you need to use the do-sql option to execute sql queries.
iwdd.ipl cfg=book3ora.cfg deployment=basearea iwdd-p=do-sql user-op=createidx
Eg:
<deployment ..>
........
<sql user-action="createidx" type="update">
create index book_idx on book_windex (author)
</sql>
</deployment>