Place

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

The Placement dialog lets you place tables and indexes on different segments. From a performance standpoint it is not recommended to have a table and its supporting indexes on the same device or disk segment. It is also good to have more frequently accessed indexes and tables grouped together on higher speed devices, if possible.

Platform Availability

To Place an Index or Table on a Segment

  1. Initiate a Place action against one or more tables or indexes. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Place wizard:
Step Settings and tasks

Action options

Use the Segment dropdown to specify the segment on which you can place objects, the default, logsegment or system.

Dependencies

Review the referring and referred objects that will be automatically resolved when you execute this operation. For more information, see Dependencies.

Preview

Preview the DDL generated for the operationn. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.