explain analyze SELECT --columns-- FROM KEY_VALUE_META_DATA t0 WHERE t0.ID_FOREIGN_TABLE = 21110::bigint;
an index is used. Very fine, the performance is about 10 to 100 times faster for the single select.
An alternative technique is to do this:
... t0.ID_FOREIGN_TABLE = '21110';
Chris
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
