I have a table partitioned by country. I have a table with the same dataset which is non-partitioned. On querying from both the tables , I find that the time taken to query on the non-partitioned table takes lesser time than querying on the partitioned table. Can anyone let me know where the issue might be and also possibly write down the solution to it ? The partitioned table is dynamically partitioned.