G
Guest
Does anybody know if it's possible to test for the existance of a table
index? I am looking to write VB code that will try and find corrupted
indexes for several tables and automaticaly fix them. I have most of it
written except for the part that actually tests it. I am using multiple
CREATE/DROP INDEX SQL statements for each table index.
Usually a compact/repair will delete damaged indexes and I run this every
morning before running maintenance on my db. So I am trying to prevent extra
long run times by automaticaly repairing damaged (deleted) indexes. Any help
is greatly appreciated.
TIA.
Rick
index? I am looking to write VB code that will try and find corrupted
indexes for several tables and automaticaly fix them. I have most of it
written except for the part that actually tests it. I am using multiple
CREATE/DROP INDEX SQL statements for each table index.
Usually a compact/repair will delete damaged indexes and I run this every
morning before running maintenance on my db. So I am trying to prevent extra
long run times by automaticaly repairing damaged (deleted) indexes. Any help
is greatly appreciated.
TIA.
Rick