General charcteristics questions
Posted in 1993
Topics: Performance & Tuning, Data Types & Schema Design, Triggers, Constraints & Referential Integrity
Hi netters !! It would be appreciated any answer on the questions that follow : 1- Maximum number of DBs within the same system ? 2- Maximum size of a DB ? 3- Maximum tables in a DB ? 4- Maximum size of a table ? 5- Maximum number of records in a table ? 6- Maximum size of a row (record) ? 7- Maximum size of a table column (: cust.name) ? 8- Maximum size of fields in a table column ? 9- Maximum number of columns per table ? 10- Maximum number or columns in a primary index ? 11- Maximum number of columns in a secondary index ? 12 - Maximum mumber of secondary indexes per table ? 13- Is there the ability of user definable data types ? 14- Is there a cost based query optimizer ? (included to the informix SE environment or as a separate product ?) 15- Is the Declarative Referential Integrity (SQL89) supported ? (Please in details if possible) 16- Are views on multiple tables supported ? 17- What are the memory requirements of the SE in a UNIX V 4.xx platform per user ? 18- Is there the ability for "two phase commit" in the SE ? All the above questions stand for the INDORMIX SE and ON-LINE on UNIX paltforms (UNIX V 4.xx) Any and every answer will be extremely appreciated !! Thank you in advance, tkon