Search

Enterprise Data Manager Guide

Enterprise Data Manager Guide

6.4.3 HotFix 1
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3

Back Next

Table Properties

Table Properties

You can view and configure properties for the tables included in a segmentation group. Required table properties include the table name and desired alias name.

The following table describes segmentation group table properties:

Field Name	Description
Table Name	Name of a table included in the segmentation group. The drop-down menu lists available tables.
Table Alias Name	Alias name for an included table. Because you can use the same table multiple times in an segmentation group, you may need to create alias names for some tables. If the table has one or more aliases, select the desired alias.
Use row count for space allocation	Displays the row count of each segment before you schedule the segmentation process. This field is optional.
History Segment Select Hint	Text used for selection SQL during segmentation and creation of split segments. This field is optional.
Insert_Update_Hint_Text	Text used to improve performance of SQL INSERT or UPDATE. This includes segmentation and all incremental data movement. This field is optional.
Optimization Index	Indicates whether the table has an associated optimization index.
Default Segment Select Hint	Inserts hints in the SELECT query that creates the default segment. This field is optional.
Default Segment Sub Query Hint	Inserts hints in the SUB query that creates a default segment. This field is optional.
History Segment Sub Query Hint	Inserts hints in the SUB query that creates a history segment. This field is optional.
ROWID Select Hint	Inserts hints in the ROWID SELECT query. This field is optional.
Row Count Hint	Inserts hints for the row count query during the Create Audit Snapshot job. This field is optional.
GatherStats PD	Inserts a table-specific parallel degree for gathering statistics. This field is optional.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.