Hi Colin, If you use the SQL Select from within MapInfo, I guess you'll need to create a index using the Table > Maintenance > Table Structure dialog. Do remember that MapInfo can't use the index in the Oracle database, these are more or less for Oracles eyes only.
I'm not sure whether this actually is possible when you are using Live ODBC/Live link. Maybe it would be faster to make a new DBMC table that retrieves a single record with the desired primary key. In this case you would aks Oracle to give the respective record. Peter ------------------------------------------------------------------------------------------------ Peter Horsb�ll M�ller, GIS Udviklingskonsulent / GIS-Developer Kampsax A/S - GIS Software & Solutions Rugaardsvej 55, 5000 Odense, DK tel: +45 6313 5013, dir:+45 6313 5008, fax: +45 6313 5090 mailto:[EMAIL PROTECTED] www.kampsax-gis.dk and www.kampsax.dk Authorized MapInfo Partner & Distributor in Denmark and Norway. ------------------------------------------------------------------------------------------------ Klik ind p� http://www.kortal.dk og se det hele lidt fra oven! ----- Videresendt af Peter M�ller/Kampsax - 10-04-2002 12:52 ----- "Thornton, Colin" <colin.thornton@infor Til: "'[EMAIL PROTECTED]'" med.co.uk> <[EMAIL PROTECTED]> cc: 10-04-2002 10:07 Vedr.: MI-L Performance of SQL SELECT I am using MapInfo 6.5 to access point data from an Oracle 817 database through a live link. The table I am accessing has 40000 points. I have created a spatial index on the table and performance when displaying, interrogating and moving the points is very fast. However when I use the MapInfo functionality to SQL SELECT a point by its primary key the search takes about 4 minutes to return. How can I improve this performance? Is it a case of adding more indexes to the field? Colin Thornton. Informed Solutions Ltd, The Old Bank, Old Market Place, Altrincham, Cheshire, WA14 4PA UK Tel: +44(0) 161 942 2000 Fax: +44(0)161 942 2015 This e-mail and any attachments are sent in confidence, subject to applicable legal privilege and upon the basis that the recipient will conduct applicable virus checks. If you receive this e-mail in error please telephone us upon receipt on the above number. You are strictly prohibited from using, copying or disseminating it or any information contained in it save to the intended recipient. You are also advised that the opinions contained within this e-mail are those of the author and may not be those of Informed Solutions, its associates or Clients. Internet communications are not secure and Informed Solutions Ltd is not responsible for their abuse by third parties, nor for any alteration or corruption in transmission, nor for any damage or loss caused by any virus or other defect. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
