Re: Avoiding rebuilding of indexes
--0__=bdgwbGN0pcCeEGAyqCZvv31Vau36z40sFIRpGoz4vuhvGQa3pImO2Oof Content-type: text/plain; charset=Windows-1254 Content-transfer-encoding: quoted-printable Why do you need to drop all =FDndexes =FDn the database unless you have a warn=FDng =FDn the log f=FDle or performance problems ? I do have a 150GB database =FDn wh=FDch I never drop any =FDndex unless= I see an exact problem . The only way to speed =FDt up =FDs to sw=FDcth the database to no logg=FD= ng mode ... Best regards ... = =20 = =20 G=F6nderilen: = =20 informix-client-tools@iiug.org, = =20 informix-list@iiug.org = =20 Jinu.Joseph@citicorp.com Bilgisine: = =20 Konu: = =20 G=F6nderen: Avoiding rebuilding of indexes = =20 owner-informix-list@iiug.iiug.org = =20 26/10/2000 17:28 = =20 = =20 = =20 = =20 Hi, We operate on a database of size 22 GB. For operational efficiency and speed it was suggested that the indexes be dropped and recreated on a weekly basis. Now the problem is that this takes 7 hours, and we dont have that much time. So there are two questions ; 1. Does the rebuilding on a weekly basis help. 2. Is there anyway to speed it up or avoid it. Regards Jinu = --0__=bdgwbGN0pcCeEGAyqCZvv31Vau36z40sFIRpGoz4vuhvGQa3pImO2Oof Content-type: application/octet-stream; name="=?Windows-1254?Q?mime001.txt?=" Content-Disposition: attachment; filename="=?Windows-1254?Q?mime001.txt?=" Content-transfer-encoding: base64 Content-Description: Text - character set unknown e1xydGYxXGFuc2lcYW5zaWNwZzEyNTBcZGVmZjBcZGVmbGFuZzEwNDV7XGZvbnR0Ymwge1xmMFxm c3dpc3NcZnBycTdcZmNoYXJzZXQwIEFyaWFsO317XGYxXGZzd2lzc1xmY2hhcnNldDIzOHtcKlxm bmFtZSBBcmlhbDt9QXJpYWwgQ0U7fX0NClx1YzFccGFyZFxsYW5nMTAzM1x1bG5vbmVcZjBcZnMy MCBIaSxccGFyDQpXZSBvcGVyYXRlIG9uIGEgZGF0YWJhc2Ugb2Ygc2l6ZSAyMiBHQi4gRm9yIG9w ZXJhdGlvbmFsIGVmZmljaWVuY3kgYW5kIHNwZWVkIGl0IHdhcyBzdWdnZXN0ZWQgdGhhdCB0aGUg aW5kZXhlcyBiZSBkcm9wcGVkIGFuZCByZWNyZWF0ZWQgb24gYSB3ZWVrbHkgYmFzaXMuIE5vdyB0 aGUgcHJvYmxlbSBpcyB0aGF0IHRoaXMgdGFrZXMgNyBob3VycywgYW5kIHdlIGRvbnQgaGF2ZSB0 aGF0IG11Y2ggdGltZS4gU28gdGhlcmUgYXJlIHR3byBxdWVzdGlvbnMgO1xwYXINCjEuIERvZXMg dGhlIHJlYnVpbGRpbmcgb24gYSB3ZWVrbHkgYmFzaXMgaGVscC5ccGFyDQoyLiBJcyB0aGVyZSBh bnl3YXkgdG8gc3BlZWQgaXQgdXAgb3IgYXZvaWQgaXQuXHBhcg0KXHBhcg0KUmVnYXJkc1xwYXIN CkppbnVcbGFuZzEwNDVcZjFccGFyDQp9DQoA --0__=bdgwbGN0pcCeEGAyqCZvv31Vau36z40sFIRpGoz4vuhvGQa3pImO2Oof--