Database Peformance Tuning

CIT 214

10 cards·by mandahope1989

Set of activities and procedures designed to reduce response time of database system

Database peformance tuning

Good database performance starts with?

Good database design

Stores most recently executed SQL statements

SQL cache or Procedure Cache

What is the typical DBMS processes?

Listener, User, Scheduler, Lock manager, Optimizer

The three phases DBMS processes queries

Parsing, Execution, Fetching

DBMS executes the query using chosen execution plan in this process?

Execution

Number of different values a column could possibly have.

Data sparsity

Algorithms based on statistics about objects being accessed.

Cost-based Optimizer

Preset rules and points

Rule-based optimizer

Refers to activities on client side to generate SQL code

SQL performance tuning