creating INDEX on Espo Db tables

[arturkulik]

my bad,

there is an index for email:
MariaDB [espocrm]> SELECT INDEX_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE...

[arturkulik]

Thank You, so i guess onlu createing index will increase speed for all queries or will it be ommited?

i can force index additionali in ORM...

[arturkulik]

Hi Guys,
has anyone created an INDEX on Email Table or any other table?
we have 270k+ emails and queries are terribly slow searching full...