Is it good programming practice to avoid the use of SELECT *. Is it better to list coloumn names. Why?

  • Interview Candidate
  • 6
  • 1604

Showing Answers 1 - 6 of 6 Answers

taraldesai

  • Jun 23rd, 2007
 

Depends, if you want certain columns then why to query whole data. bcoz it involves more IO, network traffic and many other things

  Was this answer useful?  Yes

parthokonar1

  • Aug 27th, 2007
 

Actually Oracle is made for query purpose not for FTS, and it obviously depends upon your requirements. In FTS oracle server process reads all the blocks concerned with the table and it is not so when you do a query with some indexes on the table. cache hit ratio is also decreases with the FTS. For high hit ratio it should be in the bufer cache.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions