# Clustered Indexes on all tables

**URL:** <https://forum.inductiveautomation.com/t/clustered-indexes-on-all-tables/4314>\
**Category:** Ignition\
**Created:** [April 18, 2012, 7:37pm UTC](https://forum.inductiveautomation.com/t/clustered-indexes-on-all-tables/4314 "2012-04-18T19:37:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\
**Post date:** [April 18, 2012, 7:37pm UTC](https://forum.inductiveautomation.com/t/clustered-indexes-on-all-tables/4314/1 "2012-04-18T19:37:08Z")

</div>

Can we get clustered indexes put on all the tables used by Ignition (at least for the MSSQL drivers)? Looks like they’re missing from sqlt\_sci, sqlt\_perm, sqlt\_meta, and sqlt\_err.

Seems to be a driving issue if you want to open Azure SQL up for cloud deployments.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [April 19, 2012, 3:11pm UTC](https://forum.inductiveautomation.com/t/clustered-indexes-on-all-tables/4314/2 "2012-04-19T15:11:28Z")

</div>

We can try to work towards this. Currently, the MSSQL translator creates a clustered index for the primary key. Those tables don’t specify a primary key, because it wouldn’t be a single column, and the translator system doesn’t support multi-column primary keys. However, there’s a TODO in there to change that.

I’ll have to read up on Azure and the different requirements. At any rate, I think if we just allow multi-column primary key defs, this will handle itself naturally.

Regards,

---

<div class="post-metadata">

**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\
**Post date:** [April 19, 2012, 3:30pm UTC](https://forum.inductiveautomation.com/t/clustered-indexes-on-all-tables/4314/3 "2012-04-19T15:30:42Z")

</div>

The limitation here is that Azure has no support for heaps (tables without indexes) and all indexes need to be clustered since you can’t page anything (and you’ll get error messages if they’re unclustered).