query optimizer - significado y definición. Qué es query optimizer
Diclib.com
Diccionario ChatGPT
Ingrese una palabra o frase en cualquier idioma 👆
Idioma:

Traducción y análisis de palabras por inteligencia artificial ChatGPT

En esta página puede obtener un análisis detallado de una palabra o frase, producido utilizando la mejor tecnología de inteligencia artificial hasta la fecha:

  • cómo se usa la palabra
  • frecuencia de uso
  • se utiliza con más frecuencia en el habla oral o escrita
  • opciones de traducción
  • ejemplos de uso (varias frases con traducción)
  • etimología

Qué (quién) es query optimizer - definición

FEATURE TO EFFICIENTLY EXECUTE QUERIES EFFICIENTLY IN DBMS SOFTWARES
Query optimizer; Cost-based query optimizer; Query optimisation; Query planner

Query optimization         
Query optimization is a feature of many relational database management systems and other databases such as graph databases. The query optimizer attempts to determine the most efficient way to execute a given query by considering the possible query plans.
database query language         
COMPUTER LANGUAGE USED TO MAKE QUERIES INTO DATABASES AND INFORMATION SYSTEMS SUCH AS SQL OR XQUERY
Database query language; Information retrieval query language; Query languages; Query structure; Relational database querying; List of query languages; List of data query languages; List of database query languages
<database> A language in which users of a database can (interactively) formulate requests and generate reports. The best known is SQL. (1998-04-15)
Information retrieval query language         
COMPUTER LANGUAGE USED TO MAKE QUERIES INTO DATABASES AND INFORMATION SYSTEMS SUCH AS SQL OR XQUERY
Database query language; Information retrieval query language; Query languages; Query structure; Relational database querying; List of query languages; List of data query languages; List of database query languages
An information retrieval (IR) query language is a query language used to make queries into search index. A query language is formally defined in a context-free grammar (CFG) and can be used by users in a textual, visual/UI or speech form.

Wikipedia

Query optimization

Query optimization is a feature of many relational database management systems and other databases such as NoSQL and graph databases. The query optimizer attempts to determine the most efficient way to execute a given query by considering the possible query plans.

Generally, the query optimizer cannot be accessed directly by users: once queries are submitted to the database server, and parsed by the parser, they are then passed to the query optimizer where optimization occurs. However, some database engines allow guiding the query optimizer with hints.

A query is a request for information from a database. It can be as simple as "find the address of a person with Social Security number 123-45-6789," or more complex like "find the average salary of all the employed married men in California between the ages 30 to 39 who earn less than their spouses." The result of a query is generated by processing the rows in a database in a way that yields the requested information. Since database structures are complex, in most cases, and especially for not-very-simple queries, the needed data for a query can be collected from a database by accessing it in different ways, through different data-structures, and in different orders. Each different way typically requires different processing time. Processing times of the same query may have large variance, from a fraction of a second to hours, depending on the chosen method. The purpose of query optimization, which is an automated process, is to find the way to process a given query in minimum time. The large possible variance in time justifies performing query optimization, though finding the exact optimal query plan, among all possibilities, is typically very complex, time-consuming by itself, may be too costly, and often practically impossible. Thus query optimization typically tries to approximate the optimum by comparing several common-sense alternatives to provide in a reasonable time a "good enough" plan which typically does not deviate much from the best possible result.