Sorry for asking the question before doing a complete search, I found my
answer. Simply backing up and restoring back rebuilds indexes and alter
index index_name active | inactive activates / deactivates index. These were
told in data definition guide.

-----Original Message-----
From: Çağatay Tengiz [mailto:tmd0307@...]
Sent: Tuesday, October 09, 2001 9:23 AM
To: Ib-Support
Subject: [ib-support] Activating - Deactivating Indices


Hi,

How do we activate/deactivate indexes? Or how do we rebuild indexes? And
activating/deactivating indexes is equal to rebuilding indexes?

TIA

Cagatay Tengiz
cagatay.tengiz@...

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Tengiz Engineering & Consultancy
www.tengiz.net

Phone : +90 232 388 07 01
Fax : +90 232 373 42 63

Kazim Karabekir Cad. No:47/B 35040
Bornova - Izmir / TURKEY
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-




_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com