Lesson 5 Flashcards
1
Q
table structure
A
scheme for organizing rows in blocks on storage media
2
Q
heap table
A
no order is imposed on rows
optimize inset operations
3
Q
table scan
A
reads table blocks directly, without accessing an index
4
Q
index scan
A
reads index blocks sequentially
5
Q
multi-level index
A
stores column values and row pointers in a hierarchy
6
Q
tablespace
A
database object that maps one or more tables to a single file
7
Q
Physical design
A
Specifies indexes, table structures, and partitions
Affects query performance but never affects query results
8
Q
Hash index
A
index entries assigned to buckets
9
Q
Bitmap index
A
Grid of bits
Contains ones and zeros
