Within a form I create a temp view that is created very fast. This view is a total of 2700 rows long at this time and will grow as the year progresses.
This view has only four columns. I then use a cursor to create hints based on the 50 states and DC. When testing this in a single user environment, it is lightning fast. The minute someone else logs on, it takes upwards to 3 minutes to create the hints. Two of the fields are FK indexes. But the State field is not. Can you index a field in a view "on the fly" so to speak and will that give me more speed? Or would it be best just to go ahead and put a permanent index on the table? If this may not be the problem, I will listen to any suggestions. Jim
