Index on existing table - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Index on existing table

Author

Topic

blackX
Posting Yak Master

102 Posts

Posted - 2008-06-12 : 15:27:39

I need to create two non clustered indexes on my ListCalls2 table. The problem is there is already about 75000 rows in the table. Below is the script for the table

USE [Premier]
GO
/****** Object: Table [dbo].[ListCalls2] Script Date: 06/12/2008 15:26:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ListCalls2](
[ListCallID] [int] IDENTITY(1,1) NOT NULL,
[ListID] [int] NOT NULL,
[Member_Id] [int] NOT NULL,
[CallLast] [datetime] NULL,
[CallTimes] [int] NOT NULL,
[CallTimesStart] [datetime] NULL,
[Inactive] [bit] NOT NULL
) ON [PRIMARY]

any help would be greate

Thanks in advance

blackX
Posting Yak Master

102 Posts

Posted - 2008-06-12 : 15:53:52

sorry, i need the indexes on the Member_id and ListID

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-06-12 : 17:07:15

Read Madhivanan's post here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104707

Also, use BOL, lookup create index. 75,000 rows is really nothing, I have tables with 50,000,000+ rows and they're indexed. What are you worried about?

Terry

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources