William Lai <rwie@netvigator.com> offerred:
+We alreay upgrade our database server from SE5.X to IDS 7.3. After we
+convert all the old data to the new server, we have some problems on the
+index search. For example, a table:
+
+table : ith ( ithitno, ithname ), total 1,500,000 records
+index : ith_1 on ithitno, ithname
+
+when I execute the following SQL statement :
+
+ SELECT * FROM ith WHERE ithitno="ABC" ( "ABC" is not a record in ith )
+
+it take a very long time ( few minutes ) for the SQL to return "no record
+found". At the end we find that the SQL statement only use a sequential
+search to find the record "ABC".
+
+How can I control the use of the index on IDS. Please help me. Thanks
Start off with running UPDATE STATISTICS against your databases.
Dave
Dave Kosenko davek@summitdata.com
Director of Training Services (732) 469-4070
Summit Data Group (an Informix Authorized Education Center)