InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 13:17:49 GMT20http://www.sqlservercentral.com/Forums/Topic899464-149-1.aspxI got it thanksFri, 09 Apr 2010 06:29:27 GMTchandrasekaran.ganapathyhttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspxI got it. Kingston explained well. thanksFri, 09 Apr 2010 06:27:34 GMTsubramanian22http://www.sqlservercentral.com/Forums/Topic899464-149-1.aspx[quote][b]chandrasekaran.ganapathy (4/8/2010)[/b][hr]Nice explanation. But I dint get how it is related to the database. Are you meant that if i can pull the data where index no is 3 I can use that index. is it right? But I dint find any index no. assigned to the data. Can you give example with the small sample data.[/quote]I don't understand your question. Not sure what you mean about index numbers.Fri, 09 Apr 2010 06:21:45 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspx[quote][b]chandrasekaran.ganapathy (4/8/2010)[/b][hr]Hi Kingston and all,Got it. I have read some article. So If i make a query likeSelect * from employeeId where employeeId between 'xxxxxx' and 'xxxx'or Select * from employeeId where employeeId > 'xxxxx'.These kind of query will be fetched from the database too fast using index.Please correct me if i am wrong.[/quote]Depends. If the optimizer thinks that using the index will be a faster method to fetch the required data it will use your index and fetch the data. But if it decides otherwise, it will not use your index.And did you download the book from the link provided by GSquared? I don't think you did and if you did you haven't read it. It is a free download and it will have answers to most of your questions.Fri, 09 Apr 2010 00:30:03 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspxHi Kingston and all,Got it. I have read some article. So If i make a query likeSelect * from employeeId where employeeId between 'xxxxxx' and 'xxxx'or Select * from employeeId where employeeId > 'xxxxx'.These kind of query will be fetched from the database too fast using index.Please correct me if i am wrong.Thu, 08 Apr 2010 22:29:20 GMTchandrasekaran.ganapathyhttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspxNice explanation. But I dint get how it is related to the database. Are you meant that if i can pull the data where index no is 3 I can use that index. is it right? But I dint find any index no. assigned to the data. Can you give example with the small sample data.Thu, 08 Apr 2010 22:18:21 GMTchandrasekaran.ganapathyhttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspx[quote][b]chandrasekaran.ganapathy (4/8/2010)[/b]Here What is the use of creating Index?[/quote]Allow me to answer you with a question... What is the use of having an index in a book? perhaps to allow you to find the page where some information you are looking for is instead of having to read the whole book from page one?Thu, 08 Apr 2010 12:35:17 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspxWhat a question :hehe:Thu, 08 Apr 2010 08:55:12 GMTvidya_pandehttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspxYou don't select directly from the index. You select from the table.If the index is appropriate, SQL Server will use it when you do that.To really "get" indexing, you need to take a look at the subject of "execution plans". RedGate has a good book on that subject, which is free (to download). Here's the link: [url]http://www.red-gate.com/about/book_store/sql_server_execution_plans.htm[/url]The author is a regular on this site, and very, very knowledgeable about SQL Server.Thu, 08 Apr 2010 06:55:47 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspxYou can never execute an Index. To get the data you will have to always [b]SELECT *[/b] from the table.And one more thing, is you get some script from somewhere make sure you understand it completely and then try it. You can Google for lot of information on Indexes.Thu, 08 Apr 2010 06:45:14 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic899464-149-1.aspxI have gone through this example for index in one site.create table employee1( ID int, name nvarchar (20), salary int, city nvarchar (20), region nvarchar (20) ) insert into employee1 values ('1', 'Jason', '40420', 'New York', 'W')insert into employee1 values ('2', 'Robert','14420', 'Vancouver','N')insert into employee1 values ('3', 'Celia', '24020', 'Toronto', 'W')insert into employee1 values ('4', 'Linda', '40620', 'New York', 'N')insert into employee1 values ('5', 'David', '80026', 'Vancouver','W')insert into employee1 values ('6', 'James', '70060', 'Toronto', 'N')insert into employee1 values ('7', 'Alison','90620', 'New York', 'W')insert into employee1 values ('8', 'Chris', '26020', 'Vancouver','N')insert into employee1 values ('9', 'Mary', '60020', 'Toronto', 'W')CREATE UNIQUE CLUSTERED INDEX IX_EmployeeON Employee1 ([Id], [Name] DESC)GOI have done this.But I am givingSelect * from IX_Employee.It is not working.Here What is the use of creating Index?Thu, 08 Apr 2010 06:22:26 GMTchandrasekaran.ganapathy