Is there a way to optimize this BAQ query? It gets slow for lon

Yahoo Archive
1
Thanks for the valuable info.

--- In vantage@yahoogroups.com, Jeremiah Moore <jeremiah@...> wrote:
>
> You might try and join on some additional fields between some of the tables. For instance, the EmployeeNum field exists both in the LaborHed and LaborDtl tables and it will be the same for a given timecard number. Although this field is not needed to find the correct match between the two tables, adding this field into the join between those tables may help to better utilize an index and speed up the search. You can look for other instances where this may be applicable.
>
> Whenever we have a query that is performing slowly this is something that often helps out .
>
> Thanks,
>
> Jeremiah Moore
> Director of Programming
> 2W Technologies, LLC
> Epicor Channel Partner
> ph.312.533.4033 x8046 fx.847.374.3620
> http://www.2wtech.com<http://www.2wtech.com/>
>
>
>
> [Non-text portions of this message have been removed]
>
2
You might try and join on some additional fields between some of the tables. For instance, the EmployeeNum field exists both in the LaborHed and LaborDtl tables and it will be the same for a given timecard number. Although this field is not needed to find the correct match between the two tables, adding this field into the join between those tables may help to better utilize an index and speed up the search. You can look for other instances where this may be applicable.

Whenever we have a query that is performing slowly this is something that often helps out .

Thanks,

Jeremiah Moore
Director of Programming
2W Technologies, LLC
Epicor Channel Partner
ph.312.533.4033 x8046 fx.847.374.3620
http://www.2wtech.com<http://www.2wtech.com/>



[Non-text portions of this message have been removed]