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
