Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Tam OShanter — — source: Usenet: comp.databases.informix
Hello All,
Couple of questions:
1. If I have a table with 1.8GB of data how big would my ontable index be
expected to be (I am assuming there is an algorithm to calculate this based
on the number of columns in the index)?
2. For high performance OLTP systems, am I better placing my indexes off
table or on table?
3. Why does it seem to take forever to reindex a table (not baiting here,
but I thought IFX was a very performant system. Reindexing on SQL Server or
Oracle seems to take much less time and can be done in an online manner, not
removing my table from use??)?
Any further tips you may have on idexing strategies would be welcome.
Thank you all in advance,
Tam.
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.