GURU Tip: Check Your View Sizes

One of the things that can contribute to excessive database file size is the size of the view indexes in the database. You can easily check to see how big all the views are by running the following command at the server console:

show database dbname.nsf

If you have any huge view indexes in the database, you might want to trim them down by reducing the number of sorted columns or by filtering the docs in the selection formula.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s