-
Hi all,
I have a question regarding index orgenized tables.
I have a table script as follows:
CREATE TABLE KEY_FORM (
FORM_ID NUMBER NOT NULL,
FORM VARCHAR2 (500),
FORM_TYPE_ID NUMBER,
SITE_ID NUMBER NOT NULL,
INSERT_USER VARCHAR2 (100),
INSERT_TSP DATE DEFAULT SYSDATE,
UPDATE_USER VARCHAR2 (100),
UPDATE_TSP DATE,
CONSTRAINT PK_KEY_FORM
PRIMARY KEY ( FORM_ID ))
ORGANIZATION INDEX NOCOMPRESS PCTTHRESHOLD 50 INCLUDING FORM OVERFLOW;
And 100% of rows chained
Is that normal? if not, what can I do to fix it.
Thank you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|