If you're giving the partition key you won't scan the whole table. The overhead will depend on the size or the partition.
Would be an interesting workload for our tlp-stress tool, I'll code something up for the next release. On Sun, Aug 18, 2019, 12:58 PM Rahul Reddy <rahulreddy1...@gmail.com> wrote: > Hello, > > We have a table and want to add column and select based on existing entire > primary key plus new column using allow filtering. Since my where clause > has all the primary key + new column does the allow filtering scan only the > partions which are listed or does it has to scan whole table? What is the > best approach add new column and query it based on existing primary key > plus new column? >