Query optimization
• 0 Vote(s) - 0 Average
• 1
• 2
• 3
• 4
• 5
 namitasingh Active In SP Posts: 2 Joined: Dec 2010 29-12-2010, 01:18 AM i am final year B.E student in computer science.i am making my project and implimentation on Sql Tuner. before that i need to give seminar and presentation on Query optimization and how it is implemented in Sql Tuner.i know only basic information about Query optimization so i want full seminar and presentation report on the topic "QUERY OPTIMIZATION" including its introduction, theory, basic rules,techniques, applications,advantages, disadvantages, future, current tends, uses, examples illustrating rules, supporting diagrams with their explanation.
 science projects buddy Active In SP Posts: 278 Joined: Dec 2010 29-12-2010, 09:43 AM Query Optimization For a given query, there are many plans that a database management system (DBMS) can follow to process it and produce its answer. The final output will be the same in the different methods followed, but the cost(the amount of time that they need to run) will be different. In short, Query optimization is a function of many relational database management systems in which multiple query plans for satisfying a query are examined and a good query plan is identified. There must be a trade-off between the times required to figure out the plan and run the plan. The plan that needs the least time must be chosen. Therefore a DBMS must have a query optimization. enormous cost difference can occur between two alternatives.The resource footprint of various query plans is evaluated by the cost based query optimizers. The CPU path length, amount of disk buffer space, disk storage service time etc are the resources in the computer system that are costed. The possible access paths are examined before forming the set of query plans. depending on the complexity of the SQL query, the search space can become extremely large. The two methods of optimization are: logical optimization: a sequence of relational algebra is generated to solve the query. physical optimization: the means of carrying out each operation is determined here. For full details see: en.wikipediawiki/Query_optimization infolab.stanford.edu/~hyunjung/cs346/ioannidis.pdf scribddoc/39640304/Query-Optimization scribddoc/36880940/Query-Optimization Use Search at http://topicideas.net/search.php wisely To Get Information About Project Topic and Seminar ideas with report/source code along pdf and ppt presenaion
 ghasem Active In SP Posts: 2 Joined: Feb 2011 04-02-2011, 07:52 PM hello i need a project and implimentation of query optimization with pso algorithm. help me pleace. i need a query optimization with pso algorithm. help me please.