access report pull information (50 fields) from a sql server 2005 db.form has a search field and when i type the search item(already indexed in sql tbl) sometimes it slow.I am the only person playing with the table. Do I need to setup indexes on all the required columns.Will setting up Fillfactor to 70 help.sql table has 6k+ records.
You will need to give us more information to get an accurate answer but with only 6,000 rows then the results should be pretty fast.
There are lots of things that could be contributing factors;
add the table definition to your question and some details on how the data is being retrieved and we can get closer to a solution
answered Jul 28, 2012 at 01:45 PM