[Q] How do I force usage of index

I have an OWS 7.12 application comprising 60,000 records (on a Sun Enterprise) on which even simple indexed join queries run very slowly (i.e., 'where tablea.id = tableb.id' will take 30 seconds). Using SET EXPLAIN ON it seems that none of the queries are using the indexes (all sequential scans). I have data files, indexes and blobs separated into different dbspaces and update statistics is run regularly. Is there any way I can force usage of the indexes to see if it makes any difference (presuming that the the query optimizer has decided not to use them for some reason) ? Any help gratefully acccepted regards, Finbarr -- =========================================================== Finbarr Joy Internet Services Consultant Fretwell-Downing Group Ltd. Tel: +44 (0) 114 2816112 Fax: +44 (0) 114 2816001 http://www.fdgroup.co.uk E-mail: fjoy@fdgroup.co.uk http://www.syspace.co.uk ===========================================================