Comment on query performance

[Ashutosh Dhundhara]

Hi All,

I have a table like this:

CREATE TABLE IF NOT EXISTS Posts (
    idObject int,
    objectType text,
    idParent int,
    id int,
    idResolution int,
    PRIMARY KEY ((idObject, objectType, idParent), id)
);

Now have a look at the following query:

SELECT * FROM POSTS WHERE idobject = 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