In NAV I have a table (”Production Order”) that was customized by adding various fields.
These days, all the customized fields have been replicated to another table (”Item”).
I modified my reports by just replacing the source-table (from ”Production Order” to ”Item”). The running time is now doubled for all my reports, although the two tables have the same no. of lines.
I'm guessing this is because the two tables might have different keys (I haven't checked yet).
Do you have any thoughts why this would happen? Is there anything that I could improve?
Similar reports, doubled running time