Matches in DBpedia 2016-04 for { <http://dbpedia.org/resource/Query_optimization> ?p ?o }
Showing triples 1 to 75 of
75
with 100 triples per page.
- Query_optimization abstract "Query optimization is a function of many relational database management systems. 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 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 \"finding the address of a person with SS# 123-45-6789,\" or more complex like \"finding the average salary of all the employed married men in California between the ages 30 to 39, that earn less than their wives.\" Queries results are generated by accessing relevant database data and manipulating it 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 way selected. 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 way to execute a query, 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.".
- Query_optimization wikiPageExternalLink 487912.html.
- Query_optimization wikiPageExternalLink summary?doi=10.1.1.137.3356&rank=1.
- Query_optimization wikiPageExternalLink sql-tuning.com.
- Query_optimization wikiPageExternalLink watch?v=EZ9FHvOJ0Ws.
- Query_optimization wikiPageID "3480761".
- Query_optimization wikiPageLength "15121".
- Query_optimization wikiPageOutDegree "38".
- Query_optimization wikiPageRevisionID "707017355".
- Query_optimization wikiPageWikiLink Cardinality.
- Query_optimization wikiPageWikiLink Category:Database_algorithms.
- Query_optimization wikiPageWikiLink Category:Database_management_systems.
- Query_optimization wikiPageWikiLink Category:SQL.
- Query_optimization wikiPageWikiLink Data_dictionary.
- Query_optimization wikiPageWikiLink Database.
- Query_optimization wikiPageWikiLink Database_administrator.
- Query_optimization wikiPageWikiLink Database_index.
- Query_optimization wikiPageWikiLink Dynamic_programming.
- Query_optimization wikiPageWikiLink Exists_(SQL_operator).
- Query_optimization wikiPageWikiLink Flattened.
- Query_optimization wikiPageWikiLink Hash_join.
- Query_optimization wikiPageWikiLink Hint_(SQL).
- Query_optimization wikiPageWikiLink Histogram.
- Query_optimization wikiPageWikiLink IBM.
- Query_optimization wikiPageWikiLink IBM_System_R.
- Query_optimization wikiPageWikiLink Index_scan.
- Query_optimization wikiPageWikiLink Instruction_path_length.
- Query_optimization wikiPageWikiLink Join_(SQL).
- Query_optimization wikiPageWikiLink Join_selection_factor.
- Query_optimization wikiPageWikiLink Logical_conjunction.
- Query_optimization wikiPageWikiLink Not_exists.
- Query_optimization wikiPageWikiLink Predicate_(mathematical_logic).
- Query_optimization wikiPageWikiLink Product_join.
- Query_optimization wikiPageWikiLink Query_optimization.
- Query_optimization wikiPageWikiLink Query_plan.
- Query_optimization wikiPageWikiLink Relational_algebra.
- Query_optimization wikiPageWikiLink Relational_database_management_system.
- Query_optimization wikiPageWikiLink Relational_model.
- Query_optimization wikiPageWikiLink SQL.
- Query_optimization wikiPageWikiLink Sargable.
- Query_optimization wikiPageWikiLink Select-project-join.
- Query_optimization wikiPageWikiLink Sort-merge_join.
- Query_optimization wikiPageWikiLink Tree_(data_structure).
- Query_optimization wikiPageWikiLinkText "Query optimization".
- Query_optimization wikiPageWikiLinkText "optimization".
- Query_optimization wikiPageWikiLinkText "query optimization".
- Query_optimization wikiPageWikiLinkText "query planning".
- Query_optimization wikiPageWikiLinkText "query processing".
- Query_optimization wikiPageUsesTemplate Template:Citation_needed.
- Query_optimization wikiPageUsesTemplate Template:Cite_conference.
- Query_optimization wikiPageUsesTemplate Template:Cite_journal.
- Query_optimization wikiPageUsesTemplate Template:Databases.
- Query_optimization wikiPageUsesTemplate Template:More_footnotes.
- Query_optimization wikiPageUsesTemplate Template:Reflist.
- Query_optimization subject Category:Database_algorithms.
- Query_optimization subject Category:Database_management_systems.
- Query_optimization subject Category:SQL.
- Query_optimization hypernym Function.
- Query_optimization type Disease.
- Query_optimization type Language.
- Query_optimization type Algorithm.
- Query_optimization type Language.
- Query_optimization comment "Query optimization is a function of many relational database management systems. 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 database server, and parsed by the parser, they are then passed to the query optimizer where optimization occurs.".
- Query_optimization label "Query optimization".
- Query_optimization sameAs Q2919848.
- Query_optimization sameAs Optimización_de_consultas.
- Query_optimization sameAs Optimisation_de_requête.
- Query_optimization sameAs מיטוב_שאילתות.
- Query_optimization sameAs クエリ最適化.
- Query_optimization sameAs m.09fs7f.
- Query_optimization sameAs Оптимизация_запросов_СУБД.
- Query_optimization sameAs Оптимизација_упита.
- Query_optimization sameAs Q2919848.
- Query_optimization wasDerivedFrom Query_optimization?oldid=707017355.
- Query_optimization isPrimaryTopicOf Query_optimization.