Re: Best way of tidying up the database

Posted in 1998

Joe Lumbley — Wed, 4 Feb 1998 15:23:50 GMT — source: Informix-list mailing list archive (1991-1998)

Ian Clark (ian@tubeway-army.demon.co.uk) wrote: : Hi All, : I was considering a tidy up operation on our database. In the years <snip> : 3. Produce a schema from which to re-create the database. Now would be a good time to look at such items as physical table layout (how it uses your disks) and proper extent sizing. Do your dbschema with the -ss option to preserve existing extent info. Then look at your biggest/most active tables and think about making -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998 from Prentice Hall/Informix Press. If you have debugging tips, tools, or ideas to share, please send me some e-mail. ---------------------------------------------------------------------------