Quote from Microsoft:
The SQL Server Database Engine automatically maintains indexes whenever insert, update, or delete operations are made to the underlying data. Over time (including importing, etc) these modifications can cause the information in the index to become scattered in the database (fragmented). Fragmentation exists when indexes have pages in which the logical ordering, based on the key value, does not match the physical ordering inside the data file. Heavily fragmented indexes can degrade query performance and cause your application to respond slowly. Remedy this by reorganizing the index.
Issues that you may encounter is slow response, timeout errors displaying grids, timeout errors displaying detailed reports, etc
Microsoft recommends that you run maintenance on a regular basis.
If using licensed SQL Server, you can just easily use the SQL Management Studio for the full AyaNova which includes the Maintenance Wizard that you can set up to reorganize and reindex and schedule to re-occur on a regular basis so that you do not manually have to do it every time.
Basic steps are - refer to the links above for details:
Download the Expressmaint utility from http://www.sqldbatips.com/showarticle.asp?ID=27
Extract to root of the C:\ of the SQL Express server
Download the expressmaint code from http://www.sqldbatips.com/showarticle.asp?ID=29
Create a folder called C:\Reports
From a DOS command at the C:, type in the following :
sqlcmd -S .\SQLExpress -i c:\expressmaint.sql
when it returns to the DOS command type in at C:\ DOS prompt:
expressmaint -S SQLExpress -D AyaNova -T REINDEX -R c:\reports -RU DAYS -RV 1
This attaches to the server SQLExpress, on the database AyaNova, runs the REINDEX code, and puts output into the report file located in C:\Reports.