Re: Sybase/Oracle table size limitation / Largest production database

Hi netters,

I found that inserting speed does not drop with increasing size of table. Beware of deleting something, it's getting -terrible- slow.

If you have good indexes (dates, etc) you will get very good response times. Example: concatenated index on prod_id and salery_date

   select * from table_name where prod_id = 1 and salery_date = '1-dec-95';

If you do typical decision support for example:

   select * from table_name where prod_id > 5 and salery_date between ... you will not know if this query ends this century :-)

we do decision support :-/ we have to optimize every statement by hand. Hope it's getting beter in 7.2.2, now using 7.1.3 on IBM RS6000.

HTH, best regards,

Toni

-- 
A. Dischner, AIX sysadmin, Oracle DBA           | Two planets meet;
Institut fuer Klinische Chemie                  | How are you ?
Klinikum Grosshadern                            | Bad ... , i 've got 
Ludwig Maximilians Universitaet Muenchen,  GER  | homo sapiens :-)
Marchioninistr.15 81366 Muenchen 49-89-70953202