Jamie_Yates
Active Member
Hi
Quick question, if you specify to use an index on a select/Fetch Next at design time, does the database always use this index at runtime? And what happens if you select using a view where you cannot select an index?
We have recently seen an error "Failed to find Index 35 for table F4801" this is due to the index not being in F98713. That index is on that table so should run the query OK. I didn't know JDE was so tightly connected to the indexes.
Any info would be useful.
Regards
Jamie
Quick question, if you specify to use an index on a select/Fetch Next at design time, does the database always use this index at runtime? And what happens if you select using a view where you cannot select an index?
We have recently seen an error "Failed to find Index 35 for table F4801" this is due to the index not being in F98713. That index is on that table so should run the query OK. I didn't know JDE was so tightly connected to the indexes.
Any info would be useful.
Regards
Jamie