Advanced Database Management System - Tutorials and Notes: Distributed Database Question Bank with Answers 09

Friday, 1 May 2020

Distributed Database Question Bank with Answers 09



Question:

List three situations in which adaptive query processing is beneficial.


Answer:

What is adaptive query processing?



Adaptive Query Processing (AQP) analyzes actual query run time statistics and uses that information for subsequent optimizations. It focuses on using runtime feed-back to modify query processing in a way that provides better response time or more efficient CPU utilization.
AQP addresses the problems of missing statistics, unexpected correlations, unpredictable costs, and dynamic data by using feedback to tune execution. 

Situations in which AQP is beneficial:

  • In situations where statistics are inaccurate or unavailable – e.g., query processing over a remotely stored web site.
  • In situations where statistics change over the lifetime of the query – either because the query is long running (e.g., continuous) or stats are volatile.
  • In situations with variable or unpredictable resources e.g., query processing on a cluster of shared machines

**********************

Related Questions:

 

What is adaptive query processing

When adaptive query processing is beneficial in ddb

What are the situations in which adaptive query processing is beneficial

No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents