Choice of Index - SQL table creation

[Drenaï]

Hi everyone,

I am currently working on a module based on the demodoctrine module I found on GitHub.

In this module, there are querys to create the tables. You can see them here :
https://github.com/PrestaShop/example-modules/blob/master/demodoctrine/Resources/data/install.sql

In the second one, I see the INDEX IDX_lookslikearandomnumber (id_lang)

The string after the IDX_ looks like a uniq random number.
I have some questions about it.

- Where do I find this number? Do I have to generate it manually?
- If so, what rules do I have to follow?
- How this INDEX will be used later? Is that mandatory?
- Do I have to put this IDX_xxx elsewere?

As you can see, SQL is not my speciality. Especially with prestashop where I am never sure about the rules.

Thanks for your help,

Have a nice day !

[Mediacom87]

Il y a 18 heures, Drenaï a dit :

As you can see, SQL is not my speciality. Especially with prestashop where I am never sure about the rules.

Hi,

The good SQL practices have no links with PrestaShop, it is basic SQL and therefore you must take the time to train yourself at this level, there are thousands of documentations to quickly take in hand this knowledge.

The index of a table allowing to improve the performances of the treatment of the requests thereafter, this point is capital.

[Drenaï]

Thanks for your help.