para qué sirve el "using index tablespace .."
Publicado por Karina (53 intervenciones) el 13/07/2005 08:55:56
1.QUE SIGNIFICA LA SENTENCIA "USING INDEX TABLESPACE ..." AÑADIDA A UN CONSTRAINT DE PK:
ALTER TABLE my_table_name ADD (
CONSTRAINT CONSTAINT_NAME_PK
PRIMARY KEY (FIELD_NAME)
USING INDEX
TABLESPACE a_tablespace_name
PCTFREE 10
STORAGE (INITIAL 20K NEXT 20K PCTINCREASE 0)
)
2.CUÁL ES LA DIFERENCIA CON UN INDEX CREADO EXPLÍCITAMENTE:
CREATE {UNIQUE} a_index_name ON a_table_name
(
field
)
PCTFREE 10
TABLESPACE (table_space_name)
STORAGE (INITIAL 20K NEXT 20K PCTINCREASE 0);
If UNIQUE is specified the key
in the index is force to be unique otherwise
the index is assumed to be non-unique.
ALTER TABLE my_table_name ADD (
CONSTRAINT CONSTAINT_NAME_PK
PRIMARY KEY (FIELD_NAME)
USING INDEX
TABLESPACE a_tablespace_name
PCTFREE 10
STORAGE (INITIAL 20K NEXT 20K PCTINCREASE 0)
)
2.CUÁL ES LA DIFERENCIA CON UN INDEX CREADO EXPLÍCITAMENTE:
CREATE {UNIQUE} a_index_name ON a_table_name
(
field
)
PCTFREE 10
TABLESPACE (table_space_name)
STORAGE (INITIAL 20K NEXT 20K PCTINCREASE 0);
If UNIQUE is specified the key
in the index is force to be unique otherwise
the index is assumed to be non-unique.
Valora esta pregunta
0