I hope for some helpful assistance.I am presently trying to set up a form that has a table connection or MS SQL select statement. In using SQL Profile I can see that the form is doing a full table scan . Although SQL Sever is returning these records in under a second from receiving the request Nice Form struggles in opening the form which is the point it does the full table scan to a lesser extend, on finding a searched for record .
Obviously, the way I am doing this isn't the optimal way, how best should I approach creating this form?. I have been searching lot of explainer videos for some help but did not get any useful help till now .Please help me .
Any help will be appreciated.