I am importing whole data (with out any where condition) from a database, and that database tables donot have any indexes.
Is there any impact on performance of the script if tables don't have indexes?
As per my knowledge, if the table have clustered index it will be good. because the data pages will in an order so fetching will be good.
Please correct me if i am wrong.