What is the effect of partition on below query "Select * from Table_name"

Question

I have implemented database partitioning on my database. The partitioning is done by DBMS_REDEFINITION. The question in my mind is when we execute the select * statement from the table does the partitioning affect the performance.

Tip: We are selecting entire data of a table

What is the difference between select * from Non_Partitioned_table and select * from Partitioned_table?

Answer 1

Until you have not "Where clause" in your query there is no difference between partitioned and non-partitioned tables. partition will work on conditions that you do partition with that conditions on tables. for example when you partition a table by date then every query that have date condition in where clause will be affected.