# Increasing identity extended attribute **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** identityiq\ **Created:** [April 16, 2026, 10:35am UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735 "2026-04-16T10:35:42Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Prash](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@Prash](https://developer.sailpoint.com/discuss/u/Prash)\ **Post date:** [April 16, 2026, 10:35am UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/1 "2026-04-16T10:35:42Z")
Hi everyone, We are planning to increase the number of Identity Extended Attributes in our SailPoint IdentityIQ production environment. Before proceeding with the required database changes, we wanted to check if anyone has encountered issues while making similar updates. Specifically, we are interested in understanding any potential risks, performance impacts, or challenges faced during or after the change. Additionally, we would appreciate any guidance on best practices or precautions that should be taken to ensure a smooth and safe implementation. Thank you in advance for your insights and recommendations. ---
**Author:** ![kumarSinghM](https://avatars.discourse-cdn.com/v4/letter/k/ecb155/32.png) [@kumarSinghM](https://developer.sailpoint.com/discuss/u/kumarSinghM)\ **Post date:** [April 16, 2026, 10:50am UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/2 "2026-04-16T10:50:02Z")
@Prash Refer this article of for info about extended identity attributes. > [@Brief about extended identity attributes in IIQ](https://developer.sailpoint.com/discuss/t/brief-about-extended-identity-attributes-in-iiq/83764): > > Hi All, I would like to give some idea about identity extended schema attributes: By default, when we install SailPoint, we will get 6 attributes that are searchable and indexed. Because those will be stored in a separate column of the spt\_identity table. Bsides this, by default SailPoint will give and we will map 10 extended attributes. Which means we can create 10 extended searchable attributes, which will be stored in extended1, extended2, extended3,… extended10 in the sequence (make sure t… ---
**Author:** ![neel193](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/neel193/32/34038_2.png) [@neel193](https://developer.sailpoint.com/discuss/u/neel193)\ **Post date:** [April 16, 2026, 2:36pm UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/3 "2026-04-16T14:36:38Z")
@Prash Please follow the shared above article to understand how to extend the columns. However you need to find a right balance when it comes to number of columns in a table. If you have more columns then you may see below issues: - Increased Logging Overhead → Every time you insert data, the database must write that transaction to a log file. Ex: A row with 10 columns might generate a 500-byte log entry. A row with 40 columns might generate a 1-2KB log entry. - Index Maintenance → Each index on a table must be updated synchronously during an insert. - Increase in insertion/query time → It takes slightly more time when you perform insertion/Select on a table with more columns. It will impact views as well if configured. You may not see the differences for lesser data, but where you have so many identities, having too many columns slows down the aggregation and refresh tasks. ---
**Author:** ![BhanuK1](https://avatars.discourse-cdn.com/v4/letter/b/e56c9b/32.png) [@BhanuK1](https://developer.sailpoint.com/discuss/u/BhanuK1)\ **Post date:** [April 20, 2026, 5:15pm UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/4 "2026-04-20T17:15:26Z")
This is helpful. I will try this one ---
**Author:** ![phodgdon](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/phodgdon/32/3452_2.png) [@phodgdon](https://developer.sailpoint.com/discuss/u/phodgdon)\ **Post date:** [April 23, 2026, 2:03am UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/5 "2026-04-23T02:03:50Z")
We do a lot of implementations with easily 50+ extended attributes with indexes. Mostly on Oracle, but never have had any issues. ---
**Author:** ![Prash](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@Prash](https://developer.sailpoint.com/discuss/u/Prash)\ **Post date:** [May 4, 2026, 10:35am UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/7 "2026-05-04T10:35:52Z")
Hi, Does any one please help me with the steps to increase the link extended numbers. Regards, Prashansa Rai ---
**Author:** ![Chathuryas](https://avatars.discourse-cdn.com/v4/letter/c/ee59a6/32.png) [@Chathuryas](https://developer.sailpoint.com/discuss/u/Chathuryas)\ **Post date:** [May 4, 2026, 1:41pm UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/8 "2026-05-04T13:41:23Z")
Hello @Prash , You need to go the location **identityiq\_home\WEB-INF\classes\sailpoint\object\** where identityiq\_home is identityiq installation path and add the extended attributes to the **LinkExtended.hbm.xml** file. And then connect to the console and run the command **iiq extendedSchema ,** this command creates the database scripts named **add\_identityiq\_extensions.mysql** and run the generated script in database to add the extended attributes to the Link table in identityiq database. You can find more information here [Managing Extended Attributes - Compass](https://community.sailpoint.com/t5/Technical-White-Papers/Managing-Extended-Attributes/ta-p/77088) ---
**Author:** ![Prash](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@Prash](https://developer.sailpoint.com/discuss/u/Prash)\ **Post date:** [May 7, 2026, 1:09pm UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/9 "2026-05-07T13:09:57Z")
Thanks @Chathuryas for the input ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [July 6, 2026, 1:10pm UTC](https://developer.sailpoint.com/discuss/t/increasing-identity-extended-attribute/202735/10 "2026-07-06T13:10:13Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.