What happens when a table has over 200 extents?
Posted in 1995
Hello I have a site with a very large and fragmented database. One table has over 170 extents, and many have over 8 extents. The database is in use 6 days a week, 24 hours. I need to justify taking the database down for a few days to fix things. A couple of questions. Does anyone know what happens when you go over the max number of extents for a table? Does everything stop working or just adding rows to one table? I would really like hear from anyone who has gone over the max number of extents. What kind of performance gain should we expect from fixing the extents? 10%, 20%, etc ...?? Thanks for sharing your experience. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # #############################################################################