Chapter 11 Flashcards
End users and the DBMS interact through the use of _______ to generate information.
Queries
A system will perform best when its hardware and software resources are ________.
Optimized
Database ___________ activities can be divided into those taking place either on the client side or on the server side.
Performance Tuning
__________ is another name for table space
File Group
An _________ request is a low-level read or write data access operation to or from computer devices.
Input/Output
DBMS query processing has ______ phases
Three
What are the three phases of DBMS query processing?
Parsing, execution, and fetching
The _________ analyzes the SQL query and finds the most efficient way to access the data.
Query Optimizer
Once an SQL statement is transformed, the DBMS creates what is commonly known as an ___________ plan.
Access Execution
________ are ordered sets of values that are crucial in speeding up data access
Indexes
A __________ is good for simple and fast lookup operations based on equality conditions
Hash Index
__________ is a measure of the likelihood that an index will be used in query processing
Index Selectivity
_________ is evaluated based on client perspective
SQL Performance Tuning
A conditional expression is normally expressed within the ______ or HAVING classes of an SQL statement.
WHERE
_______ helps provide a balance between performance and fault tolerance
RAID
