I have indexed all database columns of the three tables feeding the database vie

mohamedb over 8 years ago

I have indexed all database columns of the three tables feeding the database view this entity backed record grid is reading from. Still, the performance statistics show slow execution for the a!queryentity. I am attaching the numbers. Is this the norm Appian folks?

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle
A Score Level 3
over 8 years ago

What do you mean with "indexed all columns"? Did you tell the database to create an index for each of the columns? This does not feel right. For a view it would be better to just index the fields you use for joining. Try to analyse your query. See dev.mysql.com/.../using-explain.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 8 years ago

What do you mean with "indexed all columns"? Did you tell the database to create an index for each of the columns? This does not feel right. For a view it would be better to just index the fields you use for joining. Try to analyse your query. See dev.mysql.com/.../using-explain.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data