Check out the Data Dictionary Viewer. It lists the indexes that Epicor added (but I doubt user-added). In your links, try to include as many as you can from left to right within the index. There are some gotchas that knowing the right index will help.
Mark_Wonsil
(Mark Wonsil)
4
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| BAQ Fast in Designer Slow in Dashboard | 16 | 3039 | February 1, 2023 | |
| Improving BAQ Performance | 53 | 16944 | November 27, 2024 | |
| Dynamic Query and General Performance | 7 | 1247 | February 10, 2021 | |
| BAQ: Get Query Execution Plan | 5 | 2742 | October 27, 2017 | |
| Tracking Down a Speed Issue | 42 | 4345 | August 7, 2023 |