Indexing

Question

Indexing

SwivelingLeaf

Old Hand

Points: 337
More actions
September 30, 2003 at 10:32 am

#106627

This is a completely novice question ... I need to know how to set up indexes on tables and views.

"The grass is always greener over the septic tank." ~Leaf

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ray_higdon SSCarpal Tunnel Points: 4589 More actions · Answer 1

I would reccomend you search this site first, then check out some of these links below, then post more specific questions. it will save you time rather than wait for people to respond to this.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_2s6r.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/sql/sql0327.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1tbn.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_5h6b.asp

HTH

Ray Higdon MCSE, MCDBA, CCNA

------------

Ray Higdon MCSE, MCDBA, CCNA

iajm SSC Journeyman Points: 85 More actions · Answer 2

It is alright to be a novice, I am one also. Wrox has a good book "Professional SQL 2000 Programming"

Authors:

Rob Vieira

Michael Maston

ISBN number:

0-7645-4379-2

Published:

December 2000

Pages: 1424

Price:

US$ 59.99

He was able to explain indexing pretty well. There is a lot to it first of all you have to know about PK's and FK's. What I am doing to learn is I have found 2 books from 2 authors and from 2 different publishers and I have found 1 Guru that is not employed by my company this way I can ask him questions that if I asked someone at work they would wonder about me. Don't give up... These joins are giving me trouble but I will figure them out.

ray_higdon SSCarpal Tunnel Points: 4589 More actions · Answer 3

I've briefly looked through that book and it does seem good, I like Inside SQL Server 2000 by Kalen Delany as well.

Ray Higdon MCSE, MCDBA, CCNA

------------

Ray Higdon MCSE, MCDBA, CCNA

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 4

Yes but the book of Kalen is not really for novices!

But of course it gives you a complete picture what is going on behind the scene.

Bye

Gabor

Bye
Gabor

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

quote:
Yes but the book of Kalen is not really for novices!
But of course it gives you a complete picture what is going on behind the scene.

IMHO 'Inside SQL Server' is the only decent book worth reading from MS Press.

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]