HomeworkLib
Question

With the help of an example SQL query, explain the different steps that are carried out when cost...

With the help of an example SQL query, explain the different steps that are carried out when cost- based optimization is used by the optimization engine. Cleary state any assumption that you make.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

The cost based optimisation actually determines the best execution plan among the others by considering available access path and also by factoring the information available in terms of statistics done on the schema object that are being accessed by the SQL statements. The cost based optimisation is used to set a potential plan which can be based on the hints and the available path for the sql query. Moreover, the optimizer is effective in predicting the cost of each plan that are based on the statistics done from the data dictionary for data distribution and also on the storage characteristics of the table.

The cost based optimizer also helps the SQL statement for better performance of the query. By using the below line we can optimize the sql statement :

OPTIMIZER_MODE = FIRST_ROWS_10

this will help in the query for faster response.

0 0
Add a comment
Know the answer?
Add Answer to:
With the help of an example SQL query, explain the different steps that are carried out when cost...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • With the help of an example SQL query, explain the different steps that are carried out...

    With the help of an example SQL query, explain the different steps that are carried out when cost- based optimization is used by the optimization engine. Cleary state any assumption that you make.

  • Database Questions (Please help if you can) For the same query task, different DBMSs may use...

    Database Questions (Please help if you can) For the same query task, different DBMSs may use different SQL statements. true         (b)         false Given a table, any column of this table can be used as a key of the table. true         (b)         false It is allowed to have multiple keys in a table. true         (b)         false When we create a table in a DBMS, if we do not explicitly specify the database, the table can never be created the DBMS does...

  • Hi I would like to make a simple query rewriting program with Java. When I ask...

    Hi I would like to make a simple query rewriting program with Java. When I ask where question so for example, where (is the Louvre Museum located?) The answer would be the Louvre Museum is located in _____ like this Just change and re-phrase the sentence or more phrase changes if you think it is easy How can I make this simple code when users ask any where questions in prompt Please help me it would be great help to...

  • Q2. a) Explain the penetration test carried out on bitumen, state its significance and draw the...

    Q2. a) Explain the penetration test carried out on bitumen, state its significance and draw the test apparatus. b). Mention the main factors considered in the choice of construction materials at the design office – is any of them more important than the other? c). What factors affect the weldability of steel? d). Consider the iron value chain from material extraction to disposal, at what point according to your assessment is the most energy used? As a design engineer, at...

  • **************PLEASE COMPLETE PART F) ONLY************** Consider the following relational database schema (primary keys are underlined) and...

    **************PLEASE COMPLETE PART F) ONLY************** Consider the following relational database schema (primary keys are underlined) and SQL query: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) SELECT g.guestNo, g.guestName FROM Room r, Booking b, Hotel h, Guest g WHERE h.hotelNo = b.hotelNo AND g.guestNo = b.guestNo AND h.hotelNo = r.hotelNo AND h.hotelName = "Ritz" AND dateFrom >= "Jan 01, 2001" AND dateTo <= "Dec 31, 2001"; (A) state what...

  • **************PLEASE COMPLETE PART E) ONLY************** Consider the following relational database schema (primary keys are underlined) and...

    **************PLEASE COMPLETE PART E) ONLY************** Consider the following relational database schema (primary keys are underlined) and SQL query: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) SELECT g.guestNo, g.guestName FROM Room r, Booking b, Hotel h, Guest g WHERE h.hotelNo = b.hotelNo AND g.guestNo = b.guestNo AND h.hotelNo = r.hotelNo AND h.hotelName = "Ritz" AND dateFrom >= "Jan 01, 2001" AND dateTo <= "Dec 31, 2001"; (A) state what...

  • Cost Behavior Major Concept Assmt #1 Explain and give a unique example the following concepts of...

    Cost Behavior Major Concept Assmt #1 Explain and give a unique example the following concepts of cost behaviors: • Cost drivers Fixed cost and Variable Costs • CVP Analysis Write in complete sentences and pay close attention to grammar Please make sure to clearly explain the concepts as if you were teaching and explaining to another student, that has no background on these concepts. Also, make sure to use a unique example. Take this example from your own situation, either...

  • Cost Behavior Major Concept Assmt #1 Explain and give a unique example the following concepts of...

    Cost Behavior Major Concept Assmt #1 Explain and give a unique example the following concepts of cost behaviors: • Cost drivers • Fixed cost and Variable Costs • CVP Analysis Write in complete sentences and pay close attention to grammar Please make sure to clearly explain the concepts as if you were teaching and explaining to another student, that has no background on these concepts. Also, make sure to use a unique example. Take this example from your own situation,...

  • There are different rules to help managers to make ethical decisions, for example, the utilitarian rule,...

    There are different rules to help managers to make ethical decisions, for example, the utilitarian rule, moral rights rule, justice rule as well as practical rule. Use a real-life example of you to explain one of the rules, and provide personal reasons as well as research evidence to support it. Bonus discussion points on, what do you perceive cultural difference in picking which rules when making ethic decisions, please try to analyze, compare and contrast this case in a multi-national...

  • QUESTION: (Answer in SQL) Write an SQL query to find all pairs of users (A,B) such...

    QUESTION: (Answer in SQL) Write an SQL query to find all pairs of users (A,B) such that both A and B have blurted on a common topic but A is not following B. Your query should print the names of A and B in that order. BACKGROUND INFO: Users can post their thoughts in form of short messages that we call “blurts”. When signing up, users need to provide their email and a password of their choice. In addition, they...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT