Re: Comment on query performance

2016-12-29 Thread Ashutosh Dhundhara
Thanks DuyHai once again :-) On Thu, Dec 29, 2016 at 3:35 PM, DuyHai Doan wrote: > No full table scan because you specify all the partition key columns in > your WHERE clause. > > On Thu, Dec 29, 2016 at 11:02 AM, Ashutosh Dhundhara < > ashutoshdhundh...@yahoo.com> wrot

Re: Comment on query performance

2016-12-29 Thread Ashutosh Dhundhara
so the performance > depends on how "large" your partition is. For small partitions it should be > fine. > > > On Thu, Dec 29, 2016 at 10:00 AM, Ashutosh Dhundhara < > ashutoshdhundh...@yahoo.com> wrote: > >> Hi All, >> >> I have a table like this:

Comment on query performance

2016-12-29 Thread Ashutosh Dhundhara
= 1 AND objectType = 'COURSE' AND idParent = 0 AND idResolution = 1 ALLOW FILTERING Now the Partition Key is completely known, so if I use ALLOW FILTERING is there going to be any performance issue because the filtering is going to be done in a known single partition? -- Ashutosh Dhundhara