web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Included Column proper...

Microsoft Dynamics AX (Archived)

Included Column properties in Index

(0) Share

Report

Report

Posted on by @rp@n

56

Dear All,

In Index I saw

For example : SalesTable > SalesIdx > SalesId > Properties >

DataField : SalesId

Included Column : Yes or No

Can you please let me know what is the use of Included Column ?

When to set Yes and when to set No.

Please give me more shed on this.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

It helps to add non-key columns to non-clustered indexes.

Please refer below links for detailed understanding on its usage:

Create Indexes with Included Columns - SQL

docs.microsoft.com/.../create-indexes-with-included-columns

Creating Indexes with Included Columns

technet.microsoft.com/.../ms189607(v=sql.105).aspx

Index with Included Columns - Indexing guildelines

technet.microsoft.com/.../ms190806(v=sql.105).aspx

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Thanks Sukrut and Chaitanya,

I will go through. If any thing, I will ask.

Thanks!

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 16

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans