Dear all,
When I define a unique contraint like
ALTER TABLE Documents ADD CONSTRAINT Documents_pk PRIMARY KEY (id,bid);
will that be enough to prevent full table scans ?
Or should I also define the index
CREATE INDEX DocumentsI ON Documents(id,bid);
regards,
Nunki