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 |
|
kmurlikrishna
Starting Member
23 Posts |
 Posted - 2007-01-22 : 13:04:37
|
| 1) We have SQL Server 2005 database on windows 2003 server.2) What about columns in functions i.e. SUM(ABS(Col1)) OR SUM(Col2 * Col3). We create a view to select these and index on view on its computed AS column? Can we directly use vw1.AScol in query in place of these function expressions? Will the index be picked and how will cost improvement compare with that of index on normal columns.3) Can statistics be used in such a situation? |
|
|
|
|
|
Indexing on Views