TBSCAN
The TBSCAN operator performs a full table scan and reads data pages directly to retrieve the rows required
Detailed Description​
The TBSCAN operator performs a full table scan to read data pages directly retrieving the rows required. This operator can be seen when the table being read is physically small, a high percentage of the table’s rows are required by the query, no index exists or index clustering is low.
If a small percentage of the rows are being accessed, an index scan is probably more efficient. Ensure that the predicates query the columns at the leading edge of the index or if there is no index present, consider adding one. Do not ‘over index’ tables, as the subsequent maintenance of the index can be a significant overhead.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.