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.
It is safe to reorganize the indexes of a database in which interviews are currently running. However, if the database is not in use, you can rebuild the indexes instead, 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.
Note Project (case data) databases often have the same name as the project. However, if your projects share a common database, that database will possibly 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, choose: Programs > Microsoft SQL Server > Microsoft SQL Server Management Studio.
2 In the Object Explorer pane on the left of the Management Studio window, click the + symbol to expand the relevant server. Then expand the Management node.
3 Right click the Maintenance Plans node, and then click Maintenance Plan Wizard. The Maintenance Plan Wizard dialog box 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 click OK.
9 Select Tables and views from the Object list and click Next.
10 On the Select Plan Properties page, click Change. The New Job Schedule dialog box opens.
11 Enter a name for the schedule and 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