Dropping Indexing for Report Performance

The dpdbadmin dropindex command drops indexing on searchable fields that was added to enhance report performance.

It may be necessary to go through an approval process in your company before performing this task. You may also need to have a database administrator perform the task for you.

Before you use the command, prepare the following:

• Database name. You need the data source name of the database (as registered with Windows or Linux as an ODBC data source). This DSN must be registered on the computer from which the command line utility will be run.
• Database administrator account. To successfully modify the database structure, you need the username and password of a database administrator account that is able to make changes to the database structure. You must pass these credentials to the utility in the parameters of the command.

To drop indexing for report performance, use the following command:

dpdbadmin dropindex –u dbusername –p dbpassword -d dsn -level lvl

where:

• dbusername is the user name of the database administrator account.
• dbpassword is the corresponding password of dbusername.
• dsn is the ODBC data source name.
• lvl refers to the level of indexing to apply; this should be 0, 1, or 2

For more information about dpdbadmin dropindex, see dpdbadmin dropindex.