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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-10 : 08:15:43
|
| D.Harinath writes "Hi! What is exact purpose of indexing.How it will increase the performance of the quey.Can u give me example *******with code********[not an theory]For 1)Cluster and Non-Cluster indexing.when Should use cluster and should not user cluster .What is major diffrence b/w them." |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-10 : 08:21:45
|
| Read about Indexes in BOL. It's such a big topic in itself that can not be answered in just single reply.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-10 : 14:01:05
|
| If I gave you a name and asked you for that person's phone number - you'd open the phone book and find the number in seconds. If I gave you an address and asked you for that person's phone number, you'd throw the phone book at me.That's because phone books are indexed by name but not by address. |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-11 : 02:41:31
|
| Index is somthing similar to the index which we have in the book. The index at the starting of the page can be linked to the Clustered Indexing, since its extactly state, on which page what material belongs and will only point to the single page. The Non-Clustered Index can be compared with the References which we have at the end of books, where alphabetically the words are sorted out and if you want to find out somthing you have to scroll through many pages, since its point to many things. Here are some other links, which may guide you to understand this vast topic'shttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70451http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=bdaee3f7-1e15-414b-b75f-a290db645159http://blogs.conchango.com/davidportas/archive/2006/05/30/4007.aspxhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16282&whichpage=2Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-11 : 03:32:25
|
| I smell homework ... |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-11 : 14:49:01
|
| Classic job interview question.CODO ERGO SUM |
|
|
|
|
|
|
Sql Indexing