ReIndexing in As400
Posted on 2007-11-27
is there a concept in AS400 for reindexing tables?
For example, in sql server, I run DBCC Reindex('tablename').
Also, is there such thing as table fragmentation? in sql server, I run DBCC ShowContig ('tablename').
We have a client that says their AS400 system is slow. Not sure where to start. But in SQL Server, i usually start with those commands. I know part of the problem is probably our app but need to see if their db needs optimization.
My manager said there's something like rearranging physical files or something. He said for example, if 10 rows are deleted, AS400 will take up space and for example it shows more space taken. But he could be just making this up :)