| Type: | bool |
| Default: | on |
| Context: | user |
| Restart: | false |
Enables or disables the query planner's use of index-scan plan types. The default is on.
Recommendations
For interactive session use only when troubleshooting queries.
On StackOverflow
- Why is setting enable_indexscan to False not working?
- How to optimize SQL when there are array and geography in where clause in postgresql
- Postgres using primary_key index in almost every query
- Postgres returns different results when bitmap scan disabled
- Postgres 9.3.14 showing duplicate values for primary key