# DAL - No Index Tables?

**URL:** https://forum.shopware.com/t/dal-no-index-tables/62076
**Category:** Programming (EN)
**Created:** [30. September 2019 um 13:01 UTC](https://forum.shopware.com/t/dal-no-index-tables/62076 "2019-09-30T13:01:34Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![brocksinet](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/brocksinet/32/15104_2.png) [@brocksinet](https://forum.shopware.com/u/brocksinet)
#### Post date: [30. September 2019 um 13:01 UTC](https://forum.shopware.com/t/dal-no-index-tables/62076/1 "2019-09-30T13:01:34Z")

</div>

Hello,

do I understand it correct that you do not have dedicated index tables in shopware 6?

Because I executed **_bin/console dal:refresh:index_** and was searching in the db for some index tables.

Then I checked some command and only see that you update some columns in the normal table.

Is that correct? How can I as developer know which column is used from an index?

Greetings,  
Björn

---

<div class="post-metadata">

### Author: ![Oliver\_Skroblin](https://avatars.discourse-cdn.com/v4/letter/o/6bbea6/32.png) [@Oliver\_Skroblin](https://forum.shopware.com/u/Oliver_Skroblin)
#### Post date: [1. Oktober 2019 um 06:06 UTC](https://forum.shopware.com/t/dal-no-index-tables/62076/2 "2019-10-01T06:06:21Z")

</div>

Hi Björn,

I’m just not sure what exactly you mean by index tables or index columns. If by this you mean columns or tables that are filled automatically - Yes, there are.

We have certain columns in the tables (product.listing\_prices, rule.payload for example) which are automatically set by the system.

However, there are also denormalized tables that are automatically filled by the dal:refresh:index process.  
You can recognize these columns by the corresponding entity definition, because these associations or columns are marked with a WriteProcted() flag.

\* [https://github.com/shopware/platform/blob/master/src/Core/Content/Product/ProductDefinition.php#L167](https://github.com/shopware/platform/blob/master/src/Core/Content/Product/ProductDefinition.php#L167)

\* [https://github.com/shopware/platform/blob/master/src/Core/Content/Rule/RuleDefinition.php#L66](https://github.com/shopware/platform/blob/master/src/Core/Content/Rule/RuleDefinition.php#L66)  
&nbsp;

---

<div class="post-metadata">

### Author: ![brocksinet](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/brocksinet/32/15104_2.png) [@brocksinet](https://forum.shopware.com/u/brocksinet)
#### Post date: [1. Oktober 2019 um 07:40 UTC](https://forum.shopware.com/t/dal-no-index-tables/62076/3 "2019-10-01T07:40:48Z")

</div>

Thx for your feedback, this helps me to understand it ![Wink](https://forum.shopware.com/plugins/CKEditor/plugins/smiley/images/wink.png "Wink")

It is a bit sad that I can not see in the db directly if the column is write- and/or read-protected.

So from my point of view it would be cool to have some consistent suffix that tell you that also when you just check the tables.