For All...
ASAP..

Windows Server nt 2000
Procesor Xeon
2 gb RAM
Hardisk + Scsi

First.... PRogram very Running Slow...
 And then database Corrupted...
 My Action :
   A.   Gfix -mend -User ...etc....
   B.   Gfix -validate -User ...etc....
   C.   Delete From RDB$Index_segment where RDB$Index_NAme='Sumbill1'
        
( After BAckup/restore Without delete record RDB$Index_NAme='Sumbill1' still error Inconsistency..Bug Check)
   D.   Backup and Restore...
   it Work... But still have Some error (Unsuccesfulll metadata update store rdb$relation_field failed attempt store duplicated value....)
but this error just Once for this day...

How To fix it?? i hope everyone share Idea and Experience about it...

 what to typing and run "Set statistics Index Name_Index" Or "Alter Index name_index Active" every i running my application ?? Or when database Index imbalance ??

 
Thanks...

Regard
allies






[Non-text portions of this message have been removed]