Re: SET EXPLAIN question

Posted in 1994

Cathy Kipp — 13 Dec 1994 14:18:05 -0500 — source: Informix-list mailing list archive (1991-1998)

Chris Wegener writes: -> ->The manual tells me that using ROWID is 'the simplest form of ->nonsequential access' and since the 'rowid value specifies the ->physical location of the row and its page' I thought this would not ->require anything other than a direct read with an Estimated Cost of 1. ->... ->I am using Online V6. You should really not write any new code using ROWID. Use a unique index instead. ROWID is not supported the same way in versions 6 and up of the engine! Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205 Currently available from Prentice Hall, my new book (ok... my only book): Programming INFORMIX SQL/4GL: A Step-by-Step Approach (ISBN: 0-13-149394-9)