Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aprichard
Yak Posting Veteran
62 Posts |
 Posted - 2009-05-09 : 05:42:41
|
| I have table with Five Fields.I want to select records with all fields.Which statement will give high performance,select * from aselect f1, f2, f3, f4, f5 from a |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-09 : 05:52:55
|
| have you checked execution plans for both? what does it suggest? |
 |
|
|
aprichard
Yak Posting Veteran
62 Posts |
Posted - 2009-05-09 : 05:56:53
|
| Both are giving same when check with Execution Plan |
|
|
|
aprichard
Yak Posting Veteran
62 Posts |
Posted - 2009-05-09 : 05:58:55
|
| But i want to confirm that both statement giving same performance.Because my senior asked me that dont put '*' in the select that would reduce the performance,. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-09 : 06:10:33
|
| thats when you actually want only a small subset of columns when table contains a large number of columns. But i dont think in your example it will be of much difference. |
|
|
|
|
|
|
Performance