InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:29:52 GMT20http://www.sqlservercentral.com/Forums/Topic1408236-1292-1.aspxHello,There's good information on indexes on the MSDN website. Should give you the required background information:-http://msdn.microsoft.com/en-us/library/ms189271(v=sql.105).aspxRegards,AndrewTue, 29 Jan 2013 06:37:24 GMTAndrew Pruskihttp://www.sqlservercentral.com/Forums/Topic1408236-1292-1.aspx[quote][b]OTF (1/21/2013)[/b][hr][quote]That would be an incorrect term for them.[/quote] Nevertheless, it's a term I've seen used by some authors to explain the concepts of Indexes. I guess only the OP knows whether the term was used as it relates to XML Indexes or Indexes in general.[/quote]It's common and correct for Oracle users to speak that way about indexes, maybe other DBMS' too, but not for SQL Server users. I would hope that an author writing about SQL Server whose work passed through a technical editor did not publish anything discussing "secondary indexes."Mon, 21 Jan 2013 07:14:54 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1408236-1292-1.aspx[quote]That would be an incorrect term for them.[/quote] Nevertheless, it's a term I've seen used by some authors to explain the concepts of Indexes. I guess only the OP knows whether the term was used as it relates to XML Indexes or Indexes in general.Mon, 21 Jan 2013 05:42:58 GMTOTFhttp://www.sqlservercentral.com/Forums/Topic1408236-1292-1.aspx[quote][b]OTF (1/21/2013)[/b][hr]I can only imagine a writer using the term "secondary indexes" to refer to any indexes other than one on a Primary Key? [/quote]That would be an incorrect term for them. The only 'secondary' indexes in SQL are secondary XML indexes. Indexes other than the primary key are just clustered/nonclustered indexes.Mon, 21 Jan 2013 05:10:58 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1408236-1292-1.aspxI can only imagine a writer using the term "secondary indexes" to refer to any indexes other than one on a Primary Key? In that case, such indexes are used to aid or make more efficient the retrieval of data.Mon, 21 Jan 2013 04:23:25 GMTOTFhttp://www.sqlservercentral.com/Forums/Topic1408236-1292-1.aspxNo such thing as a secondary index. Do you mean a secondary XML index?Thu, 17 Jan 2013 02:40:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1408236-1292-1.aspxHi all,What are secondary indexes in SQL Server and why are they needed.Thu, 17 Jan 2013 02:21:28 GMTShadab Shah