Why is SEQ SCAN faster than index scan?
Same number of evaluated record and less effort-per-record. You only win with an index if you can evaluate fewer records to make up for the extra effort per record that querying an index involves compared to just reading the actual data.
This is an environment t
est but i'm running the same test on a production environment and also seq scan is cheaper than index.
Define (or show) production...
David J.
