wlwebb
asked on
Access - FE/BE ran Analyze Performance - It suggested an Index????
Hello Experts....
I have a split DB FE/BE and I ran the Performance Analyzer and the Results suggested adding an Index for a Field in one of my tables.
I was in the Front End when I ran it..... I Clicked Optimize and I realized that I was in the Front End and not the Back End....
I then Opened the Back End and Ran the same Performance Analyzer... (the one in Access itself) In the Back End It gave NO Suggestions.... However, I looked at the table of the one field I had clicked "Optimize" when I was in the Front End and there wasn't any change to that Field.... I looked at the Settings in the table and for that field the "Indexed" was still set to NO...
So that begs a couple questions...
A) Should you allow Access to Optimize a Table from the Front End or does it even work....
B) Should you just take the suggestion from the FE and go do it in the BE...
OR
Did I just screw up that table when I click on Optimize from the FE???
I have a split DB FE/BE and I ran the Performance Analyzer and the Results suggested adding an Index for a Field in one of my tables.
I was in the Front End when I ran it..... I Clicked Optimize and I realized that I was in the Front End and not the Back End....
I then Opened the Back End and Ran the same Performance Analyzer... (the one in Access itself) In the Back End It gave NO Suggestions.... However, I looked at the table of the one field I had clicked "Optimize" when I was in the Front End and there wasn't any change to that Field.... I looked at the Settings in the table and for that field the "Indexed" was still set to NO...
So that begs a couple questions...
A) Should you allow Access to Optimize a Table from the Front End or does it even work....
B) Should you just take the suggestion from the FE and go do it in the BE...
OR
Did I just screw up that table when I click on Optimize from the FE???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Simon....
They did make sense. Both were on Yes/No fields that I used to filter (ie: ClosedShift and VoidShift)
I am relatively new to DB so SQLServers are beyond me at this point but both you and Nick have given some good info, just not sure I'm ready to tackle that yet.....
I'm going to close this an award the points
In the meantime... Does the analyzer-suggested index make sense to you, given the queries, forms and reports that you have defined in the FE? ....
They did make sense. Both were on Yes/No fields that I used to filter (ie: ClosedShift and VoidShift)
I am relatively new to DB so SQLServers are beyond me at this point but both you and Nick have given some good info, just not sure I'm ready to tackle that yet.....
I'm going to close this an award the points
ASKER
Thank you for the input..........!!!!
ASKER