October 7, 2008 04:43pm pdt

1. chapmandew 2,223,259
2. angelIII 1,997,731
3. mark_wills 631,410
4. aneeshatti... 607,479
5. ScottPletc... 456,851
6. EugeneZ 366,402
7. ee_rlee 353,240
8. BrandonG... 340,310
9. acperkins 335,429
10. dtodd 304,879
11. momi_sa... 194,132
12. cs97jjm3 188,038
13. matthews... 169,999
14. appari 166,334
15. nmcdermaid 165,158
16. rickchild 165,060
17. brejk 163,902
18. dqmq 156,258
19. Thomasian 153,702
20. dportas 141,305
21. ptjcb 140,761
22. dbaSQL 139,392
23. bhess1 134,605
24. mwvisa1 128,997
25. MohammedU 125,975

1. angelIII 10,954,144
2. aneeshatti... 4,665,358
3. acperkins 4,323,889
4. ScottPletc... 4,270,903
5. arbert 2,245,195
6. chapmandew 2,223,259
7. Lowfatsp... 2,174,384
8. EugeneZ 1,642,564
9. imran_fast 1,482,261
10. rafrancisco 1,460,132
11. Hilaire 1,221,775
12. nmcdermaid 1,149,742
13. Nightman 1,146,504
14. Mr_Peer... 1,087,815
15. ptjcb 1,074,620
16. bhess1 1,071,597
17. dtodd 891,222
18. adathelad 777,208
19. Sirees 776,352
20. appari 753,571
21. BriCrowe 722,959
22. matthews... 692,331
23. amit_g 683,229
24. mark_wills 631,410
25. ShogunW... 619,598

01.16.2008 at 08:15AM PST, ID: 23087412

	[x] Attachment Details

Primary Keys and indexing for Performance

Asked by rito1 in MS SQL Server

Tags: SQL Server

Hi All

I have a table that has 21 columns and 860,000+ rows of data. Currently this table doesn't have any indexes or a primary key. It is now starting to struggle particularly with queries using DISTINCT statements.

I have to work out what indexes to add to the table to help it's performance but in the meantime does just adding a primary key help with speed?

Also if there are several columns that are used within different stored procedures, would there be any harm adding several indexes to the 1 table other than the increace in capacity?

Many thanks

Rit
Start Free Trial

Keywords: Primary Keys and indexing for Perform…

	Title
1	Primary key as a clustered index?
2	ASP.NET: Table Adapters and SELE…
3	capacity planning in SQL server
4	no unique index found for the referenc…
5	EASY - Capacity of access database
6	MySQL SELECT DISTINCT query help.

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Primary Keys and indexing for Performance

Asked by rito1 in MS SQL Server

Tags: SQL Server

About this solution