Re: rowid ?

Hello K.Hong, Tuesday, October 12, 1999, 7:30:31 AM, you wrote: KHL> on informix online5, we used rowid in most of the 4GL KHL> code and AIK, INFORMIX IDS ver7 doesn't support rowid KHL> column. Any idea why they discarded the rowid ? (may KHL> be they encourage user to make use of primary key KHL> rather than rowid) if I insist to use the rowid to KHL> minimise the code changes any idea how it can be done ? ver7 supports rowid but Informix NOT welcome ROWID using. For example "select * from too_big_table order by rowid" query is not optimized and works too long time rather query where "order by <index_expr_or_primary_key_or_any_columns_with_indexes>" statement was used. Some troubles with rowids exists on a fragmented tables. In this case read docs on ver7 and select a better solution youself. ------------- Best regards, Dmitry mailto:buzzard@deponet.uz