I have seen some slight performance degradation above 4 indices. I usually
recommend that you have no more than 6, but 5 or even 6 can be ok, in a pinch.
So the answer is that you're approaching the point where there will be a
measurable negative impact on throughput. The complete answer is test
That completely depends on how densely the index is populated.
Example by extremes: If you index on a status code that has only two
equally possible values, you'd have about 5.5 million records in each
index. Updates to that file will grind to a near halt. If the code
could have a couple
I've never heard about MINIMUM.MODULUS, but then again when I did most of my
operations database work late last century, dynamic files did not exist.
I've never heard of split operations either.
Here are all the ANALYZE.FILE results:
ANALYZE.FILE ABC
File name .. ABC
...
File
The date index would contain internal-format dates, and there would be one
for every record, as it is the POST.DATE.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/