CREATE TABLE bd.details
(
  id serial NOT NULL,
  manid integer NOT NULL,
  pweight double precision,
  plength double precision,
  pwidth double precision, 
  phigh double precision, 
  pnidrating integer,
  partno character varying(20) NOT NULL, 
  weightrating integer,
  countryid integer DEFAULT 0,
  CONSTRAINT pk_maincat PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE bd.details
  OWNER TO postgres;

CREATE UNIQUE INDEX idx_det_1_man_part
  ON bd.details
  USING btree
  (manid, partno COLLATE pg_catalog."default");

SELECT * FROM "bd"."details" WHERE "details"."id" = 1001

SELECT * 
FROM   "bd"."ordertab" AS "Extent1"
       JOIN "bd"."details" AS "Extent2"
         ON "Extent1"."pnid" = "Extent2"."id"
WHERE "Extent1"."orderid" = 164

"Merge Join  (cost=1.92..1.98 rows=1 width=172) (actual time=6464.726..6464.728 rows=1 loops=1)"
"  Merge Cond: ("Extent2".id = "Extent1".pnid)"
"  ->  Index Scan using pk_maincat on details "Extent2"  (cost=0.56..1770536.37 rows=37769472 width=62) (actual time=0.014..4879.081 rows=27123967 loops=1)"
"  ->  Sort  (cost=1.35..1.35 rows=1 width=110) (actual time=0.045..0.045 rows=1 loops=1)"
"        Sort Key: "Extent1".pnid"
"        Sort Method: quicksort  Memory: 25kB"
"        ->  Seq Scan on inordertab "Extent1"  (cost=0.00..1.34 rows=1 width=110) (actual time=0.026..0.030 rows=1 loops=1)"
"              Filter: (id = 164)"
"              Rows Removed by Filter: 26"
"Planning time: 0.543 ms"
"Execution time: 6464.827 ms"