references/official-docs.md

# Official SQL documentation entrypoints

Use documentation for the **user's actual platform and version**. These are discovery links; some platform pages move as versions evolve.

- PostgreSQL: https://www.postgresql.org/docs/current/ ; EXPLAIN: https://www.postgresql.org/docs/current/using-explain.html
- MySQL: https://dev.mysql.com/doc/refman/8.4/en/
- SQL Server and Azure SQL T-SQL: https://learn.microsoft.com/en-us/sql/t-sql/language-reference
- Azure Synapse dedicated SQL pool: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/
- Oracle SQL language reference: https://docs.oracle.com/en/database/
- Snowflake: https://docs.snowflake.com/en/sql-reference ; query history/profile: https://docs.snowflake.com/en/user-guide/ui-snowsight-query
- BigQuery GoogleSQL: https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax ; performance: https://cloud.google.com/bigquery/docs/best-practices-performance-compute
- Databricks SQL: https://docs.databricks.com/aws/en/sql/ ; query profile: https://docs.databricks.com/aws/en/sql/user/queries/query-profile
- Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/
- Microsoft Fabric SQL: https://learn.microsoft.com/en-us/fabric/data-warehouse/

## High-value current details
Google BigQuery cautions that LIMIT with SELECT * does not alone reduce bytes scanned. Databricks profiles expose scan, join, shuffle and memory information for diagnosis. PostgreSQL EXPLAIN ANALYZE executes the statement; avoid casual use for destructive operations. All must still be verified for the target environment.