Tablescan or TableSPACEscan

I have a tablespace that contains two tables: a very large one and a small one.

If a query on the small table results in a full tablescan, does this mean that only the table data is scanned, or does the database have to scan through all bits that are stored in de tablespace that holds the table? How should the database know where the records of the small table are physically stored?

Thanks
Michiel Brunt Received on Mon Sep 10 2001 - 02:00:47 CDT