Well, this is just the way it works, sorry... But you have a few possiblities:
1. Create index in SQL Server and use these by sending the request thru the DBMS-driver to the SQL Server. Now it will be SQL Server that will execute the query and return the result. 2. Use Download method when opening tables from SQL Server. This gives you the possibility to create index in MapInfo on the downloaded table. Now the query can be executed inside MapInfo with a much better performance. Do remember to use Refresh to send/retrieve changes. HTH, Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk > -----Original Message----- > From: Korkovelos, Dina E, NEO [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 26, 2004 5:02 PM > To: [EMAIL PROTECTED] > Subject: MI-L MapInfo SQL SERVER INDEXES > > > Anyone have experience with MapInfo for SQL Server and > Indexing. I am using Easyloading for upload into SQL Server 2000. > > I have a terrible time in query data after opening the table > in MapInfo (super slow). When I try to Index in SQL Server, > it does not appear in MapInfo and I can't index the table in > MapInfo because I'm connected to it via ODBC. Any suggestions? > > Thanks! > > Dina Korkovelos > Geographic Data Analyst > Media Planning & Implementation > AT&T NEO > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > THIS MESSAGE IS INTENDED ONLY FOR THE INDIVIDUAL OR ENTITY TO > WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS > PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER > APPLICABLE LAW. IF THE READER OF THIS MESSAGE IS NOT THE > INTENDED RECIPIENT OR THE EMPLOYEE OR AGENT RESPONSIBLE FOR > DELIVERING THE MESSAGE TO THE INTENDED RECIPIENT, YOU ARE > HEREBY NOTIFIED THAT ANY DISSEMINATION, DISTRIBUTION OR > COPYING OF THIS COMMUNICATION IS STRICTLY PROHIBITED. > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | > www.directionsmag.com | To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > Message number: 10612 > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10613
