Hi guys,
I got the following index:
CREATE INDEX "ix_mo_pk" ON "mo" USING "btree" ((("id")::"text"))
The "ID" is my primary key:
"mo_pkey" PRIMARY KEY, "btree" ("id")
The ix_mo_pk index is not being used... But as it has the "ID" on it, I wanted to ask before dropping it.
Can you guys explain me if the ix_mo_pk is safe to delete and why?
The mo_pkey index is being used.
I'm using Postgres 9.2
Thanks
Patrick