Performance optimization in sql.

Question

I have 2 questions related sql performance.

 

1. we need to select 1 crore data than how we can improve performance of query.

2. We need to insert 1 crore data than how we can improve performance while inserting data in sql table.