Database re-indexing is a process to improve the overall performance of a database. Re-Indexing a database helps to quickly locate data without having to search every row in a database table every time a database table is accessed. eG recommends re-indexing the eG database on a regular basis.
Database reindexing can be configured as a SQL job, and scheduled to run at a frequency desired. Follow the steps below to create a SQL job to perform database reindexing.
- Start the process by logging into the SQL Server Management Studio as an Administrator and then Expand “SQL Server Agent” as shown in the Fig below
- Do Right-click on the jobs and click on “New Job” to create a new Job as shown in the Fig below
- Now Enter “ Name “ , “Owner” and Description for the Job as shown in fig below
- After creating a Job, Do a Right-click on the newly created a job for the database Indexing, Select Properties as shown in fig below.
- Now Select Steps in the Job Properties as shown in fig below
- In the New Job Step click on “Advanced “, here you can specify how do you want the job on Both “success” and Failure Actions then click on Ok when you have done as shown in fig below
- Click on General, to choose eG Database, select the command file by using “open”. Then select the eG Database from the list and paste the Database index queries from the re-index file that eG Provides. Finally, click on “OK” as shown in fig below.
- Please contact eG helpdesk to get the SQL index rebuild query
- Now you can see the Steps created for the Specific Job as shown in fig below.
- Select Schedules from the properties and click on “New” as shown in Fig,
- New Job Schedule window will evoke and ask for the parameters like “Name” “schedule type” , Frequency at which the Job should run and you can mention at what time on a specific day the job should run and so on and click on “OK” as shown in the below.
- Below fig shows “Schedule” is created