Archives of the TeradataForum
Message Posted: Wed, 30 Aug 2000 @ 07:44:57 GMT
I doubt that adding new users will sort the index out. Adding rows to a table normally just adds entries to the index rather than rebuilding it.
To answer some other points raised in this thread;
- you may need to bypass accessrights in order to ins or delete (I think by default DBC doesn't have this privilege, but yours wouldn't be the first system I've seen where this has been added)
- from what I remember of the original Checktable error, your problem is that there are too many index entries (rather than say base rows without index entries). In this case you may well get away with no problems during normal processing - it all depends on whether those extra index entries are for tvm's which actually exist or not.
- dbc.accessrights can be skewed (well, usually 'lumpy' rather than skewed) but I doubt whether it's a major issue.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|