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

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

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