Answer: The best query is
Select ID,Name from Table1
Don't use
Select * from Table1
As it creates an extra overhead and reduces performance. Always fetch only those column which are needed to get better performance.
Asked In: Many Interviews |
Alert Moderator