Re: informix vs oracle

utkanbir compared IDS and that other thing: > 3. Nologging operations: IDS also allows non-logged tables, called RAW tables: The following is from the IDS 10 doc, because I can link directly to the appropriate passage, but is true for IDS 7.31, 8.x, and 9.3 and higher (not certain about 9.2): RAW tables are nonlogging permanent tables and are similar to tables in a nonlogging database. RAW tables use light appends, which add rows quickly to the end of each table fragments. Updates, inserts, and deletes in a RAW table are supported but not logged. RAW tables do not support indexes, referential constraints, or rollback. You can restore a RAW table from the last physical backup if it has not been updated since that backup. Fast recovery rolls back incomplete transactions on STANDARD tables but not on RAW tables. A RAW table has the same attributes whether stored in a logging or nonlogging database. RAW tables are intended for the initial loading and validation of data. To load RAW tables, you can use any loading utility, including dbexport or the High-Performance Loader (HPL) in express mode. If an error or failure occurs while loading a RAW table, the resulting data is whatever was on the disk at the time of the failure. It is recommended that you do not use RAW tables within a transaction. Once you have loaded the data, use the ALTER TABLE statement to change the table to type STANDARD and perform a level-0 backup before you use the table in a transaction. This is from the Administrator's Guide: http://publib.boulder.ibm.com/epubs/html/25122670/admin357.htm Raw tables are quite useful when loading but the lack of indexes, referential constraints, and rollback can make other processing rather tedious. Sincerely, Christopher Coleman President Kansas City Informix Users Group www.iiug.org/kciug Database Analyst Medication Management Mediware Information Systems, Inc.