Disabling SQL rewriting will omit all query tags, i. e. disable node access checks as well as override hook_query_alter() implementations in other modules.
WARNING: Disabling SQL rewriting means that node access security is disabled. This may allow users to see data they should not be able to see if your view is misconfigured. Use this option only if you understand and accept this security risk.
This will make the view display only distinct items. If there are multiple identical items, each will be displayed only once. You can use this to try and remove duplicates from a view, though it does not always work. Note that this can slow queries down, so use it with caution.
This will make the query attempt to connect to a replica server if available. If no replica server is defined or available, it will fall back to the default server.
If set, this comment will be embedded in the query and passed to the SQL server. This can be helpful for logging or debugging.
If set, these tags will be appended to the query and can be used to identify the query in a module. This can be helpful for altering queries.