Hi Chethan   Thanks for the reply as per your examples   1. select name from census where year=2010; This works fine ie it only queries the partition but our problem is when the condition is not a literal like ='2010' but when we try to dynamically retrieve the data like your second example   We are finding that the query scans the whole table not just the partition - ie takes much longer in larger tables   ... View more