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 ChristineH
Certified Lead Developer
over 8 years ago

In addition to the log that Jonathan mentioned, execute explain plan on your view. How many full table scans are occurring?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 8 years ago

In addition to the log that Jonathan mentioned, execute explain plan on your view. How many full table scans are occurring?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data