# Tables without Index

**URL:** <https://community.dynatrace.com/t/tables-without-index/19943>\
**Category:** Open Q&A\
**Tags:** databases\
**Created:** [August 2, 2020, 11:55am UTC](https://community.dynatrace.com/t/tables-without-index/19943 "2020-08-02T11:55:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Babar\_Qayyum](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/babar_qayyum/32/13620_2.png) [@Babar\_Qayyum](https://community.dynatrace.com/u/Babar_Qayyum)\
**Post date:** [August 2, 2020, 11:55am UTC](https://community.dynatrace.com/t/tables-without-index/19943/1 "2020-08-02T11:55:29Z")

</div>

Dear All,

Can we know the database tables’ names having no index?

Regards,

Babar

---

<div class="post-metadata">

**Author:** ![AntonioSousa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antoniosousa/32/50_2.png) [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\
**Post date:** [August 2, 2020, 6:10pm UTC](https://community.dynatrace.com/t/tables-without-index/19943/2 "2020-08-02T18:10:56Z")

</div>

Since Dynatrace monitors from the application level, there is no way to know whatever Indexes a table might have.

If you have Oracle, and are using Oracle Insights, at the query level, you can get the Execution Plans, and there you can confirm if your queries are using Indexes or not.