Postgresql disable sequence scan

To optimize some query, sometime we need to disable sequence scan, run this before query:
Set enable_seqscan = off;

Then do analyze to your query


Popular posts from this blog

Ports to allow for whatsapp call

Setting open office u label tom & jerry

Tips Jika Mobil Anda Habis Bensin LOL!