SQL Indexes and InfoPath

R

ridawg

Hey,

I've created an InfoPath form that queries a table in SQL. My question is
does it help from a performance standpoint to create an Index on the table.

I've been using the form without an Index but the retrieval of data can be a
little slow - nothing unreasonable considering the amount of data in the
table.

But I was curious so I created an Index on the table to see if that would
speed up my query. I haven't noticed any increase in performance but this is
the first form I have running against SQL so for all I know I didn't set up
my Index right. Just curious if anyway else has played around with this.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Index into a Table 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
Open form 0
Sharing Access MDB or Accdb with client using older or newer version of Office 1
Access to database denied and Full Trust 1
Infopath SQL Behavior 2
Creating a Search using a combo box and then creating a report. 4

Top