Indexing on Views

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

Posted On: Monday 26th of November 2012 01:53:49 AM Total Views:  341
View Complete with Replies