Subject | Index selectivity in TEMP Table |
---|---|
Author | |
Post date | 2014-10-01T20:27:06Z |
(FB 2.5)
Hello! I have some temp tables in order to select records. Like this:
CREATE GLOBAL TEMPORARY TABLE SEL_STO (
ID INTEGER NOT NULL
) ON COMMIT DELETE ROWS;
ALTER TABLE SEL_STO ADD CONSTRAINT PK_SEL_STO PRIMARY KEY (ID);
My question is: it makes sense having a PK in this table? The statics, shows always "0"
How is the selectivity of that index?
Thanks!!
Hello! I have some temp tables in order to select records. Like this:
CREATE GLOBAL TEMPORARY TABLE SEL_STO (
ID INTEGER NOT NULL
) ON COMMIT DELETE ROWS;
ALTER TABLE SEL_STO ADD CONSTRAINT PK_SEL_STO PRIMARY KEY (ID);
My question is: it makes sense having a PK in this table? The statics, shows always "0"
How is the selectivity of that index?
Thanks!!