Order by performance

Post Reply
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

Order by performance

Post 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?
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Order by performance

Post 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.
John Turnbull
Thunderstone Software
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

Order by performance

Post 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..
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Order by performance

Post 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.
John Turnbull
Thunderstone Software
Post Reply