# Were indexes always included in sqlt\_data\_\* tables?

**URL:** <https://forum.inductiveautomation.com/t/were-indexes-always-included-in-sqlt-data-tables/108985>\
**Category:** Ignition\
**Created:** [July 28, 2025, 12:41am UTC](https://forum.inductiveautomation.com/t/were-indexes-always-included-in-sqlt-data-tables/108985 "2025-07-28T00:41:10Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [July 28, 2025, 4:42am UTC](https://forum.inductiveautomation.com/t/were-indexes-always-included-in-sqlt-data-tables/108985/4 "2025-07-28T04:42:34Z")

</div>

Well, here is a post where I was clearly positive that they were not there by default in 7.9.

> [@Tag Historian/SQL Crashing](https://forum.inductiveautomation.com/t/tag-historian-sql-crashing/84302/13):
>
> The performance issues come in if no indexes have been added to the tables (they aren't there by default in 7.9) and so the database engine will have to trudge through all of that data to gather the information being requested, and that can kill a server that doesn't have enough memory available

---

_[View the full topic](https://forum.inductiveautomation.com/t/were-indexes-always-included-in-sqlt-data-tables/108985)._