How do I optimize database?

Posted in 1999

bahins — Mon, 26 Jul 1999 06:00:10 GMT — source: Informix-list mailing list archive (1991-1998)

Can someone please help me? How do I optimize my Informix Online Dynamic Server 7.3 databases? Will oncheck do the job? Thanks. -- Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm).

↪ replying to bahins

Art S. Kagel — Mon, 26 Jul 1999 14:50:15 -0400 — source: Informix-list mailing list archive (1991-1998)

No. Oncheck examines the physical structure of the server's disk space looking for physical and logical damage and inconsistencies that may result from hardware problems or system crashes. What do you mean specifically by optimize? Do you mean that in the PC sense as in "I want to optimize my D: drive."? You can do that several ways: 1) Unload the data using the dbaccess UNLOAD command, drop and recreate the table empty, reload the data using the dbaccess LOAD command or the dbload utility. 2) Do the same using dbexport/dbimport. 3) Cluster an index on each table: ALTER INDEX fred TO CLUSTER; If the index is already clustered then just uncluster it first (ALTER INDEX fred to NOT CLUSTER;) 4) Use the ALTER FRAGMENT syntax to recreate the table compressed: ALTER FRAGMENT ON TABLE wilma INIT IN some_dbspace; You can do this back to the same dbspace the table is already in but moving the table to a clean, empty,compressed dbspace will give slightly better results. Obviously this is for a non-fragmented table. For fragmented tables replace the single IN clause with an appropriate fragmentation expression. Art S. Kagel bahins wrote: > > Can someone please help me? > > How do I optimize my Informix Online Dynamic Server 7.3 databases? > > Will oncheck do the job? > > Thanks. > -- > Posted via Talkway - http://www.talkway.com > Exchange ideas on practically anything (tm).

↪ replying to bahins

ktroxel@my-deja.com — Tue, 27 Jul 1999 22:59:41 GMT — source: Informix-list mailing list archive (1991-1998)

In article <KPSm3.5995$J5.68435@c01read02-admin.service.talkway.com>, "bahins" <bgates@hotmail.com> wrote: > Can someone please help me? > > How do I optimize my Informix Online Dynamic Server 7.3 databases? > > Will oncheck do the job? > > Thanks. > -- > Posted via Talkway - http://www.talkway.com > Exchange ideas on practically anything (tm). > > Surely you've got to be kidding..... Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.