is it possible to use Sql Server "Indexed Views" in any way in AX 2012? We will get the enterprise edition of SQL Server and i found this feature really interesting.
If yes: Is there any documentation how to use indexed views in Sql Server 2012?
Thanks in advance,
I dont have sure but maybe the following link can help you... i hope so!!
Dont forget to mark this as answer!
Francisco Silva | | http://fsilvajunior.blogspot.com.br
This posting is provided "AS IS" with no warranties, and confers no rights.
thanks for answering.
But i did not found a property in AOT which give me the same functionality. Indexed Views are a feature from SQL Server (see msdn.microsoft.com/.../ms191432.aspx).
I thought the only way is to use OdbcConnection or CCADOConnection.
I don't think Indexed view is supported in AX2012. On the other hand, support of "included columns" is added in AX2012, but you might already know that.
My blog | PBC
This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
well, i have heard about "included columns". That will help a little - but indexed views would be much nicer :).