What is the implication of the SAMPLE BLOCK(1) in the following query?
SELECT COUNT(*) from TABLE_A SAMPLE BLOCK(1)
I assumed that this would return all of the rows in the first block of the TABLE_A data segment, but the number of rows that is being returned is over 100,000 and with a 16K block size I can hardly believe that there are that many rows in one block.