Please Explain What Is Wrong With This Query “select * From Table_n

1.	Please Explain What Is Wrong With This Query “select * From Table_name” ?
Answer» You should never select all columns of a table UNLESS NEEDED and specify the columns only required in the query. The reason is that it will use a lot of memory to FETCH the data, if the records are huge, when you are going to use only 2 or 3 FIELDS from the table. You should never select all columns of a table unless needed and specify the columns only required in the query. The reason is that it will use a lot of memory to fetch the data, if the records are huge, when you are going to use only 2 or 3 fields from the table.

Please Explain What Is Wrong With This Query “select * From Table_name” ?

Answer»

You should never select all columns of a table UNLESS NEEDED and specify the columns only required in the query. The reason is that it will use a lot of memory to FETCH the data, if the records are huge, when you are going to use only 2 or 3 FIELDS from the table.

You should never select all columns of a table unless needed and specify the columns only required in the query. The reason is that it will use a lot of memory to fetch the data, if the records are huge, when you are going to use only 2 or 3 fields from the table.

Discussion

No Comment Found

Related InterviewSolutions

Please Explain The Output Of The Code Provided Below And Explain The Reasoning ? $a = 012; Echo $a / 4;
What Is Sql Injection And How Do You Deal With That ?
Please Explain What Is Wrong With This Query “select * From Table_name” ?
How To Destroy A Cookie ?
How Can We Unset The Variable Of A Session ?
How To Destroy A Session Variable ?
Please State How Can You Take A Backup Of The Whole Database In Mysql ?
Can You Increase The Maximum Upload Size In Php ?
Can You Increase The Execution Time Of A Php Script ?
What Php Image Functions Do You Use To Get The Properties Of An Image ?