Reorganizing indexes
To maintain good performance, reorganize the indexes of your UNICOM Intelligence Interviewer project databases regularly, particularly if your projects are running large numbers of interviews.
You can reorganize the indexes of a database in which interviews are currently running. However, if the database is not in use, you can instead rebuild the indexes, which runs more quickly and can result in greater optimization. For more information about rebuilding indexes, see the SQL Server Books Online documentation.
The procedure for reorganizing indexes depends on the version of the SQL Server Client Tools that you are using.
Project (case data) databases often have the same name as the project. However, if your projects share a common database, that database might have a generic name such as “Respondents”. For more information, see
Project (case data) databases.
Using Microsoft SQL Server to reorganize indexes
1 From the Windows Start menu, click Programs > Microsoft SQL Server > Microsoft SQL Server Management Studio.
2 In the Object Explorer pane, click the + symbol to expand the relevant server, and then expand the Management node.
3 Right‑click the Maintenance Plans node, and then click Maintenance Plan Wizard. The Maintenance Plan Wizard dialog opens.
4 If an introduction page is displayed, click Next.
5 On the Select a Target Server page, enter a name for your maintenance plan and make sure that the value of Server is correct. Click Next.
6 On the Select Maintenance Tasks page, select Reorganize Index, and then click Next.
7 On the Select Maintenance Task Order page, click Next.
8 On the Define Reorganize Index Task page, select These databases from the Database list, then select the database for your project, and then click OK.
9 Select Tables and views from the Object list, and then click Next.
10 On the Select Plan Properties page, click Change. The New Job Schedule dialog opens.
11 Enter a name for the schedule, and then specify the schedule for your maintenance plan. Click OK.
12 On the Select Plan Properties page, click Next.
13 On the Select Report Options page, choose whether you want the output from the maintenance plan to be written to a text file or to be sent by email. Click Next.
14 On the Complete the Wizard page, click Finish.
The maintenance plan is created. It will execute at the time that you defined.
15 Click the Maintenance Plans node in the Object Explorer pane. The maintenance plan is listed on the Summary tab. Double-click the maintenance plan to view or edit it.
See also