title: Optimize the query "Select * from tableA"
body: <p>I was asked in an interview to enlighten the ways one can use to optimize the query <code>Select * from TableA</code> if it is taking a lot of time to execute. (TableA) can be any table with large amount of data. The interviewer didn't leave me any option like to select few columns or to use "WHERE" clause rather he wanted me to give solution for the subject query.</p>