| Type: | bool |
| Default: | on |
| Context: | user |
| Restart: | false |
| Since: | 18 |
Enables or disables the query planner's optimization which analyses the query tree and replaces self joins with semantically equivalent single scans. Takes into consideration only plain tables. The default is on.