June 25, 2013 at 2:48 am
Hello
I have this table in sql server 2008 r2 which is populated periodically by a job. This table is used in a stored proc called by about 40 reports in ssrs.
I am in the process of creating indexes on this table. Any suugestions / help would be valuable.
Table structure (just including the bare minimum columns out of about 40)
Deptid productid customerid territoryid salespersonid areaid areamanagerid netsales netsalesqty yearmonth
1. Sales person, area managers. Dept heads and above log in to view reports.
2. Reports have filters like dept, territory, customer, area, territory, product, month and year.
3. Reports are grouped by dept / area / product
4. Users can see data only relevant to them or further on the filters they select
Thanks
June 25, 2013 at 5:22 am
Step 1. Find out if any missing indexes on the Table which you are using. Create important missing indexes.
Step 2. Find out queries taking more time on specific Table and study query plan and check if creating additional index improve the performance.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply