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';


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to