You probably don’t want to set this option unless you’re finding your query to be especially slow. For better performance, you can set "orderingSpecifier": "discard".
The purpose of this option is to specify how a parent view’s ORDER BYs interact with a derived view you’re querying.
| Value | Is Default | Description |
|---|---|---|
| total | yes | Make sure that both the parent and derived views’ rows are ordered |
| no_preserve | Ignore the parents’ ORDER BYs when determining row order |
|
| discard | Ignore both the parents’ and derived view’s ORDER BYs |