Hint (SQL)

From Seo Wiki - Search Engine Optimization and Programming Languages

Jump to: navigation, search

In various SQL implementations, a hint is an addition to the SQL standard that instructs the database engine on how to execute the query. For example, a hint may tell the engine to use as little memory as possible (even if the query will run slowly), or to use or not use an index even if the query optimizer would decide otherwise.

Different database engines use different approaches in implementing hints. MySQL uses its own extension to the SQL standard, where a table name may be followed by USE INDEX, FORCE INDEX or IGNORE INDEX keywords[1]. Oracle implements hints by using specially crafted comments in the query that begin with a + symbol, thus not influencing SQL compatibility[2].

See also


ru:Подсказка в SQL-запросе
Personal tools

Served in 0.094 secs.