Question Status

Unanswered
F. Peters asked a question on 11 Sep 2013 6:01 AM

Hello,

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,

Frank

Reply
Francisco Silva responded on 11 Sep 2013 7:15 AM

I dont have sure but maybe the following link can help you... i hope so!!

msdn.microsoft.com/.../aa869223.aspx

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.

Reply
F. Peters responded on 12 Sep 2013 12:52 AM

Hi Francisco,

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.

Frank

Reply
Dominic Lee responded on 12 Sep 2013 1:23 AM

Hi Frank,

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.

Regards,

Dom

kind regards,

Dominic Lee

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.

Reply
F. Peters responded on 12 Sep 2013 2:49 AM

Hi Dom,

well, i have heard about "included columns". That will help a little - but indexed views would be much nicer :).

Frank

Reply