Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
3,921,064,411 visitors served.
forum Join the Word of the Day Mailing List For webmasters
?
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

cost-based query optimizer
(redirected from Query optimizer)

    Also found in: Wikipedia 0.01 sec.
cost-based query optimizer
Software that optimizes an SQL query for the fastest processing, based on the size of the file and other variables.
Want to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit the webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link 		Feedback
Mentioned in?  References in periodicals archive?   Encyclopedia browser?   Full browser?
No references found
 
A word of caution though that if you are doing joins with multiple files the system may need to build a temporary index and this can take awhile depending on the data files in use and other factors used by the AS/400s query optimizer engine.
AS/400 Queries Are Easy as Pie by John Andersen / Computers and Internet community
Sections cover foundations, identification of performance problems, the query optimizer, and optimization.
Troubleshooting Oracle performance by SciTech Book News
EXPLAIN PLAN' AND 'ORACLE TRACE ' Explain plan is a SQL statement listing the access plan selected by the query optimizer.
Measuring oracle performance by Smith, William / Database and Network Journal
 
 
 
Encyclopedia
?

Terms of Use | Privacy policy | Feedback | Advertise with Us | Copyright © 2012 Farlex, Inc.
Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.