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 of hundred equally different values, update
overhead might be acceptable.
The same logic applies as to whether or not to use the NO.NULLS
option when creating the index.
--
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678 Web: www.oliver.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On Sep 12, 2007, at 11:39 AM, Louie Bergsagel wrote:
Does anyone know the effect of adding an index to a UniVerse file?
I'd like to add a date index to a type 30 file with 11 million
records. (
ANALYZE.FILE Total size ................. 2,115,325,952 bytes)
Would this have any measurable speed slowdown on applications running
against the file?
The file currently has 4 other indexes.
-- Louie Bergsagel
Seattle
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
