Doyce-
Perhaps if you post the query we can suggest another way to solve it.
No, AFAIK, you cannot define an index in a View. Are you completely locked out of the ERP tables design? Surely defining an index to aid performance won't affect the way the ERP software runs. (It might actually help!)
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Mar 7, 2014, at 6:33 PM, <winberry.doyce@roadsysinc.com> <winberry.doyce@roadsysinc.com> wrote:
Hello friends,
I have a query with a subquery from linked tables to an SQL database that runs really slow. I'm sure it's because the Vendor ID field does not have an index. Since this table is part of my ERP software suite, I can't modify the table therefore I'm wondering if I can create a view of the table and add the index there. I don't know much about SQL server so if this can be done, can someone please tell me how to do this with SQL Management Studio?
Doyce
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar