Proper words in proper places, make the true definition of a style.
The summarization of details into a smaller number of summary
datapoints (sums, counts, and averages, usually), usually using
A correlation join applied
Tables that hold somewhat different, but related entity types within the same physical table.
A balanced, branched, sorted structure that allows the database to rapidly locate a row or set of rows that match conditions of the indexed column or columns.
The smallest unit of physical storage or cached storage in a database. Blocks are usually just a few kilobytes in size and most often contain from less than one hundred rows to at most a few hundred rows.
The cache that stores recently used table and index blocks in shared memory for logical I/O, avoiding the need for physical I/O of the cached blocks. Any user’s SQL can read blocks into the block buffer cache, and any other user’s SQL automatically takes advantage of these cached blocks. See LRU caching.
An index block that the database reaches from a root block or a higher branch block. The branch block, in turn, points to leaf blocks or lower branch blocks that contain entries in the desired range. See root block and leaf block.
The fraction of logical I/Os that avoid physical I/Os.
A join between two ...