Revision history [back]

No, a full table scan is not the outcome of using the IN() operator to filter by partition key. When using the IN() operator to filter by partition key, the database engine can use an optimized query plan that only scans the relevant partitions instead of scanning the entire table. This can significantly improve the query performance. However, if the partition key is not properly indexed or if the IN() list contains too many values, then the database engine may still need to perform a full table scan.