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 |
|
visolve
Starting Member
6 Posts |
 Posted - 2008-08-20 : 01:44:33
|
| Hi,I have a select query which selects around 40 columns and build 70-80 virtual columns (using CASE and AS).. In my where clause i use only 2 columns.. the Query takes around 3-5 secs. HOw can i optimize it using index. I tried various indexing but that dosen't help.. ThanksViSolve |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-20 : 01:59:43
|
| what does your execution plan suggests? you need to create index only after making sure it is properly used in the query. |
 |
|
|
visolve
Starting Member
6 Posts |
Posted - 2008-08-20 : 02:48:49
|
| sorry new to sqlserver.... The thing is we call the select query from a stored procedure passing the table name and condition..When i tried execution plan it shows 0.0% cost.. i suppose it is wrong.. can u educate me on how to do that? |
|
|
|
|
|
|
SQL server - SELECT Query - Indexing