General information
Forum:
Microsoft SQL Server
Category:
Database management
Hi Daniel,
Sorry for jumping in. We do have indexes and the table we are looking at is an attendance table table which is huge. So I was thinking whether we can have a view for the active attendance records for the year and use a VFP remote view with parameters to look at those the user interested.
What is your opinion?
Thanks in advance.
Regards.
>What indexes do you have on the table? Indexes are the single best way to increase performance.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only