When you generate the physical database schema from a physical model, you can include your indexes as part of the schema. The index definitions are translated into the appropriate schema statements and the specified parameter information is inserted in the correct syntax. You can generate schema statements for primary key, alternate key, foreign key, inversion entry key, and clustered indexes.
You can generate schema statements for physical storage objects if the server supports the option and you select the option in the Schema Generation Report dialog.
When you reverse engineer a database, you can import the name, definition and parameters of each index defined on the server. When you import the index information from a server, the storage location information for each index is maintained. Therefore, you can recreate the database using the same storage assignments. You do not have to manually reassign the storage location for each index.
After you import indexes, you can view or modify the index properties, definitions and table associations in the Indexes dialog. If your target database is DB2 z/OS, Informix, Oracle, SQL Server, or Sybase, you can assign an index to a physical storage object in the Indexes dialog. If your target database is DB2 z/OS, Informix, and Oracle, you can also modify the storage parameters in the Indexes dialog.
If the target server is DB2 z/OS, Informix, Oracle, or Sybase, and any physical storage option is selected, the schema includes index physical storage parameters in the schema statement.
|
Copyright © 2013 CA.
All rights reserved.
|
|