-
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.