Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE "TIR"."INT07NCMP"(
- "INT07_CORRELATIVO" NUMBER(10) NOT NULL ENABLE,
- "INT07_CENTRO" VARCHAR2(4 BYTE) NOT NULL ENABLE,
- "INT07_CODCOMPONENTE" VARCHAR2(18 BYTE) NOT NULL ENABLE,
- "INT07_ALMCOMPONENTE" VARCHAR2(4 BYTE) NOT NULL ENABLE,
- "INT07_CANCOMPONENTE" NUMBER(13,3),
- "INT07_UNICOMPONENTE" VARCHAR2(3 BYTE),
- "INT07_CODPORTADOR" VARCHAR2(18 BYTE) NOT NULL ENABLE,
- "INT07_ALMPORTADOR" VARCHAR2(4 BYTE) NOT NULL ENABLE,
- "INT07_CANPORTADOR" NUMBER(13,3),
- "INT07_UNIPORTADOR" VARCHAR2(3 BYTE),
- "INT07_ALMDESTINO" VARCHAR2(4 BYTE) NOT NULL ENABLE,
- "INT07_FECINICIO" VARCHAR2(10 BYTE) NOT NULL ENABLE,
- "INT07_HORINICIO" VARCHAR2(8 BYTE) NOT NULL ENABLE,
- "INT07_FECTERMINO" VARCHAR2(10 BYTE) NOT NULL ENABLE,
- "INT07_HORTERMINO" VARCHAR2(8 BYTE) NOT NULL ENABLE,
- "INT07_ESTPOCH" VARCHAR2(1 BYTE),
- "INT07_TMPPOCH" TIMESTAMP (6),
- "INT07_ESTSAP" VARCHAR2(1 BYTE),
- "INT07_TMPSAP" TIMESTAMP (6),
- "INT07_TIMESTAMP" TIMESTAMP (6) NOT NULL ENABLE,
- CONSTRAINT "INT07NCMP_PK" PRIMARY KEY ("INT07_CORRELATIVO"),
- CONSTRAINT "INT07NCMP_UK1" UNIQUE (
- "INT07_CENTRO", "INT07_CODCOMPONENTE", "INT07_ALMCOMPONENTE", "INT07_CODPORTADOR", "INT07_ALMPORTADOR",
- "INT07_FECINICIO", "INT07_HORINICIO", "INT07_FECTERMINO", "INT07_HORTERMINO"
- )
- );
- CREATE INDEX "TIR"."INT07NCMP_IDX1" ON "TIR"."INT07NCMP" ("INT07_CENTRO", "INT07_ESTPOCH");
- CREATE INDEX "TIR"."INT07NCMP_IDX2" ON "TIR"."INT07NCMP" ("INT07_CENTRO", "INT07_ESTSAP");
- CREATE INDEX "TIR"."INT07NCMP_IDX3" ON "TIR"."INT07NCMP" ("INT07_CENTRO", "INT07_CORRELATIVO", "INT07_FECINICIO", "INT07_HORINICIO", "INT07_FECTERMINO", "INT07_HORTERMINO");
- SELECT * FROM INT07NCMP
- WHERE INT07_CENTRO = '7100'
- AND INT07_CORRELATIVO > 0
- Plan hash value: 2810525850
- ----------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- ----------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 9770 | 1450K| 1 (0)| 00:00:01 |
- |* 1 | TABLE ACCESS BY INDEX ROWID| INT07NCMP | 9770 | 1450K| 1 (0)| 00:00:01 |
- |* 2 | INDEX RANGE SCAN | INT07NCMP_IDX1 | 39 | | 1 (0)| 00:00:01 |
- ----------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 1 - filter("INT07_CORRELATIVO">0)
- 2 - access("INT07_CENTRO"='7100')
- Note
- -----
- - dynamic sampling used for this statement (level=2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement