What Are law_dba_index Table Descriptions?

The columns in law_dba_index match the descriptions of the columns in law_dba_table with the following exceptions.

• The pct_used, null_date, and uvarchar columns are not used.

• The Degree and instances values in law_dba_index columns override any values set in law_dba_table columns.

The following columns exist in law_dba_index but not in law_dba_table.

Column	Description
INDEX_NAME	The name of the Lawson index whose storage parameters are described by the row. If a Lawson table has no value in law_dba_index, the database driver uses the default values to create and maintain the index. All values must be uppercase to be valid.
NOSORT	Whether to ignore sorting when creating the index. Allows values of Y (Yes) or N (No). The default is N. If NOSORT is set to Y, rows store in the table in ascending order and do not need to be sorted when creating the index.

The following output file shows the definition of law_dba_index as described by the build_law.sql script.

create table law_dba_index (
table_name varchar2(30) not null,
index_name varchar2(30) not null,
tablespace_name varchar2(30),
ini_trans number check (ini_trans between 2 and 255),
max_trans number check (max_trans between 2 and 255),
initial_extent number,
next_extent number,
min_extents number check (min_extents > 0),
max_extents number,
pct_increase number,
pct_free number check ((pct_free >= 0) and (pct_free < 100)),
nosort char(1),
freelists number,
freelist_groups number,
parallel char(1),
degree number,
instances number,
primary key (table_name, index_name)
);
BEGIN

UPDATE LAW_DBA_COMMENTS SET comments = '9IX'
WHERE object_name = 'LAW_DBA_INDEX'
AND object_type = 'TABLE';
IF SQL%ROWCOUNT = 0 THEN
INSERT INTO LAW_DBA_COMMENTS(object_name, object_type, comments)
VALUES ('LAW_DBA_INDEX', 'TABLE', '9IX');
END IF;
COMMIT;
END;
/