# EasyChart DB Pen Diagnostic Time column is not indexed

**URL:** <https://forum.inductiveautomation.com/t/easychart-db-pen-diagnostic-time-column-is-not-indexed/37444>\
**Category:** Ignition\
**Created:** [August 6, 2020, 10:00am UTC](https://forum.inductiveautomation.com/t/easychart-db-pen-diagnostic-time-column-is-not-indexed/37444 "2020-08-06T10:00:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yfactor](https://avatars.discourse-cdn.com/v4/letter/y/e79b87/32.png) [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\
**Post date:** [August 6, 2020, 10:00am UTC](https://forum.inductiveautomation.com/t/easychart-db-pen-diagnostic-time-column-is-not-indexed/37444/1 "2020-08-06T10:00:48Z")

</div>

Hi there,  
Can anyone help me understand what is wrong with the t\_stamp column I am trying to use for my DB Pen please? I ran the diagnostic and I got this not indexed message. and basically an error on the chart. the time column i am trying to use is sql datetime column.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/2/c29446d62a3af925cc48f595f370b22673e9fc11.png)  
It looks like this  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/4/44f044ab86047c2e2f1f5d857ab8e3b8b9cb063b.png)

---

<div class="post-metadata">

**Author:** ![Kevin.McClusky](https://avatars.discourse-cdn.com/v4/letter/k/47e85d/32.png) [@Kevin.McClusky](https://forum.inductiveautomation.com/u/Kevin.McClusky)\
**Post date:** [August 6, 2020, 10:36am UTC](https://forum.inductiveautomation.com/t/easychart-db-pen-diagnostic-time-column-is-not-indexed/37444/2 "2020-08-06T10:36:56Z")

</div>

You’ll need to add an index to daytime in your database management software.

If you’re unfamiliar with the concept of indexes in general, here’s a primer. [https://www.essentialsql.com/what-is-a-database-index/](https://www.essentialsql.com/what-is-a-database-index/)

For whatever database you’re using, just google “How to add an index \<database type\>” and you should find plenty of results.

---

<div class="post-metadata">

**Author:** ![Yfactor](https://avatars.discourse-cdn.com/v4/letter/y/e79b87/32.png) [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\
**Post date:** [August 6, 2020, 10:55am UTC](https://forum.inductiveautomation.com/t/easychart-db-pen-diagnostic-time-column-is-not-indexed/37444/3 "2020-08-06T10:55:53Z")

</div>

Thanks for that Kelvin.  
Ya i just started learning SQL last week or so. not familiar at all with database…  
I will have a look at the link you gave me.  
Cheers