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 |
|
PriyaRavi
Starting Member
3 Posts |
 Posted - 2004-05-28 : 00:45:31
|
| Hi,Can anybody tell whether performance will be affected if we give a query like1. select column1,column2 from tablename1 where 1<(select max(column n) from tablename2)Need to know whether 1 can be used instead of column12. select name ,column2,column3 from <t.name> where name="?"Need to know whether the column used in where condition can be used in select query. Though , it is not necessary, need to know whetherperformance will be affected.3. Using min, max, count(*) functions.Thanks in advance |
|
|
vganesh76
Yak Posting Veteran
64 Posts |
Posted - 2004-05-28 : 08:08:11
|
| Aggregate function are used based on the requirements.Columns that are appearing in Where Clause can appear in ur select that doesnt affect performance. See to that u dont include columns that are not required. To improve performance u can create Indexes on columns that appear in the WHERE clauseEnjoy working |
 |
|
|
PriyaRavi
Starting Member
3 Posts |
Posted - 2004-06-10 : 03:48:34
|
| Hi,What about the following query ?select column1,column2 from tablename1 where1<(select max(column n) from tablename2)1 can be used instead of column name ?Priya |
|
|
|
|
|
|
Performance