Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Create Clustered index in Dynamics AX 2009

23 views
Skip to first unread message

DBA

unread,
Jul 16, 2010, 2:45:20 AM7/16/10
to
Hi

I'm now using Dynamics AX 2009

I wanna create clustered index for performance. but I don't know how to
create clustered index by using Dynamics AX.

For example, CustTable.AccountIdx is a clustered index. but I coundn't find
how to configure clustered index.

AOT => Click Data Dictionary => Click Tables => find CustTable => Indexes =>
AccountIdx

AccountIdx has data fields which are AccountNum and DataAreaId. but There's
no property which configure clustered index..

How could I configure clustered index by using Dynamics AX..

Thanks in advance.. :)

DBA

unread,
Jul 16, 2010, 4:47:13 AM7/16/10
to
Ignore this

I found how to create clustered index in dynamics AX

Kenneth A. Larsen

unread,
Jul 16, 2010, 9:34:28 PM7/16/10
to

"DBA" <D...@discussions.microsoft.com> wrote in message
news:B0A75384-0F6D-4DE6...@microsoft.com...

You're welcome. But Dynamics is cool.

Klaas Deforche

unread,
Aug 4, 2010, 5:11:03 AM8/4/10
to
Should anyone else have the same question:
Go to the table in the AOS, right click and open properties.
There is a property named CusterIndex there where you can select you cluster
index.

Best regards,
Klaas.
----------------
http://www.artofcreation.be

Kenneth A. Larsen

unread,
Aug 23, 2010, 10:00:02 PM8/23/10
to

"Klaas Deforche" <KlaasD...@discussions.microsoft.com> wrote in message
news:DE5D7195-AC27-4C46...@microsoft.com...

Kenneth A. Larsen

unread,
Aug 30, 2010, 4:16:32 PM8/30/10
to

"Kenneth A. Larsen" <Lar...@verizon.net> wrote in message
news:7C142D10-9774-4697...@microsoft.com...

0 new messages