Hi! I have this DDL for a table, and due to

Question

Hi! I have this DDL for a table, and due to

a constraint, Postgres itself generates a unique index (automatically):
CREATE TABLE public.maiquel_midia
(
seqmidia serial4 NOT NULL,
midia varchar(255) NOT NULL,
regra bool NOT NULL,
margem numeric(12, 3) NULL,
competitividade numeric(12, 3) NULL,
oculto bool NOT NULL,
CONSTRAINT maiquel_midia_pkey PRIMARY KEY (seqmidia)
);

The automatic generated index is (pg_catalog.pg_indexes):
CREATE UNIQUE INDEX maiquel_midia_pkey ON public.maiquel_midia USING btree (seqmidia)

Is it redundant for me to create another index?
CREATE INDEX maiquel_midia_seqmidia_idx ON public.maiqwuel_midia USING btree (seqmidia);

#programming #russian

0

04.10.2023

1 ответов

8 просмотров

Slava Rozhnev SQLtest.online https://phpize.online · Accepted Answer

Slava Rozhnev SQLtest.online https://phpize.online

Yes, you should not create additional index

0

9 месяцев назад

169 похожих чатов

Hi! I have this DDL for a table, and due to

1 ответов

Похожие вопросы