If you ask it nicely, <G> SQL server will provide you with this information and allow you to make the choice of creating the index to significantly speed up that search. This has 2 positive effects. The search or program you create this for will be much faster. The resources being used by SQL Server to do this are considerably less, which results in better overall performance for everything else.
Even in cases where their aren't customizations, without maintenance, performance will degrade over time.
There are many ERP Systems that rely on SQL server as their back end. Some ERP vendors optimize these against a set load and modify queries and indexes accordingly. Others do not.
Without optimization specific to these, overall performance suffers.
We can help identify the items that aren't efficient and assist in improving them.
In all cases, they are unable to predict all custom searches and reports the end user might create.
If the secretary is asked to find this information often enough, he or she might create index cards listing the page each street is found on. The next time the question is asked, it is answered in minutes instead of hours or days. SQL server works in a very similar fashion. Like the secretary, it knows when the question is asked and how much an index is likely to help. Unlike the secretary, it keeps track of how often this happens and how much time would be saved by creating the index.
Think of your ERP program as a manager or data analyst. Through various programming techniques it requests data from your SQL server.
Think of SQL server as an assistant or secretary. In a fashion very similar to a real secretary, it retrieves data. If the data is unorganized or organized in a way that doesn't help, this takes much longer.
For example, to find everyone who lives on a certain street in a phone book arranged by first or last name, you would need to read each and every page. If the information is in a database where the index is on the first or last name, SQL server needs to view every row in that table.
We can help create the indexes and maintenance plans that will allow SQL server to always be at its best.
Your data becomes fragmented over time and is spread over many area of the disk or over many disks. We can assist in bringing it back together, making requests for data quicker.