Page 1 of 1
Order by performance
Posted: Mon Mar 08, 2004 2:58 pm
by MiniMe
Does the existance or non-existance of indexes on a column that is used in an order by affect the performance of the query?
Order by performance
Posted: Mon Mar 08, 2004 3:52 pm
by John
Maybe. It should never hurt to have an index. How much it helps may vary based on the version of Texis you have, and the query. An inverted index will help with the order by, a compound field in a metamorph index will help if the index would be used otherwise, and a regular index will help if no other index can be used.
Order by performance
Posted: Mon Mar 08, 2004 3:55 pm
by MiniMe
the database table in question has something like 20 indexes on it and our maintenance activity is getting slower and slower the bigger the table gets so we are looking to drop some of the 20. Maybe 2 or 3 of them but were concerned if we would impact the order by of the queries where it is used. We are currently on
Texis Web Script (Vortex) Copyright (c) 1996-2002 Thunderstone - EPI, Inc.
Commercial Version 4.02.1033654782 of Oct 3, 2002 (alpha-dec-osf4.0-64)
Which is pretty old by now I am sure..
Order by performance
Posted: Mon Mar 08, 2004 6:16 pm
by John
You may want to contact Tech Support directly with the queries you are concerned with and the indexes you have. They may be able to offer more specific advice to your situation.