Hi all
I have a rather large table, around 7 million rows. I created 3 indexes on
this table, which resulted in rather large indexes. As there will be no
more rows added to this table, I thought optimizing the indexes with the
CLUSTER command might be a good idea to speed up lookups. After the first
index had finished being processed by the cluster command, my remaining
indexes diappeared. The actual index files in the ~/data/base/dbname
directory had completely disappeared. Therefore I have to go and re-create
the indexes. Have I missed something in the release notes or known bugs
list, or is there a size limitation or problem when dealing with indexes
and/or clustering them? The average physical index file size being around
200MB each.
My version btw is 7.0.2 running on FreeBSD 3.4.
cheers,
Jason Davis
DB Admin/Programmer
Tas Access
www.tassie.net.au