Revision as of 10:34, 13 June 2018 edit Sandstein (talk \| contribs) Autopatrolled, Administrators 188,299 edits m Removing link(s): Wikipedia:Articles for deletion/Mike Ault closed as delete (XFDcloser) ← Previous edit		Revision as of 03:57, 7 July 2018 edit undo Blaxthos (talk \| contribs) Extended confirmed users, Pending changes reviewers, Rollbackers 16,596 edits →Implementation: mssql fix Next edit →
Line 7: * [[Oracle Database\|Oracle]] implements hints by using specially-crafted [[SQL#Other\|comment]]s in the query that begin with a <tt>+</tt> symbol, thus not affecting SQL compatibility.<ref>Mike Ault: [http://www.dba-oracle.com/t_sql_hints_tuning.htm Oracle SQL Hints Tuning]</ref> * Postgres Plus® Advanced Server (a proprietary version of [[PostgreSQL]] from [[EnterpriseDB]]) offers hints compatible with those of Oracle.<ref>[http://www.enterprisedb.com/docs/en/9.2/perffeat/Postgres_Plus_Advanced_Server_Performance_Guide-33.htm Postgres Plus Advanced Server Performance and Scalability Guide: Query Optimization Hints]</ref><ref>[http://www.enterprisedb.com/docs/en/9.2/oracompat/Postgres_Plus_Advanced_Server_Oracle_Compatibility_Guide-75.htm Postgres Plus Advanced Server Oracle Compatibility Developer's Guide: Optimizer Hints]</ref> * [[MSSQL]] \|Microsoft SQL Server]] -offers hints avia ~~good~~the ~~study~~<tt>OPTION</tt> ~~guide on this topic could be found here :~~keyword <ref> ~~a good study guide -~~ [https://~~technet~~docs.microsoft.com/en-us/~~library~~sql/~~2007.11.sqlquery.aspx]~~t-sql/queries/hints-transact-sql-query?view=sql-server-2017 MSSQL 2017 Documentation]</ref> ==See also==

Hint (SQL): Difference between revisions