Data Warehousing Community Forum
February 09, 2012, 12:05:51 am

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Indexes in SQL server  (Read 1414 times)
unknown
DW Apprentice
**

Reputation: +8/-0
Offline Offline

Posts: 44



View Profile
« on: September 12, 2007, 08:43:38 pm »
What are the different types of indexes available with Microsoft SQL Server?

Is there any difference between oracle and Microsoft SQL Server Indexes.

Help is appreciated..
Logged
Thanks
Unknown Smiley
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: February 07, 2008, 12:31:11 pm »
The main difference between indexing in SQL Server and Oracle is that SQL Server (2005) supports B*Tree indexes on an XML field's elements, values, and paths. Oracle has no XML specific indexing technique available. It only supports regular text indexing and functional indexes.
Logged
If most people said what’s on their minds, they’d be speechless.
herbert11
DW Apprentice
**

Reputation: +4/-0
Offline Offline

Posts: 25


View Profile
« Reply #2 on: September 07, 2011, 12:46:08 pm »
Microsoft SQL server enable you to use many types of indexing. These indexing are clustered indexing, non-clustered indexing, unique, index with included columns, full text indexing, and XML indexing.
Logged
Adline30
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 3


View Profile
« Reply #3 on: December 22, 2011, 12:36:42 pm »
I am trying to understand how the indexes are managed for below common data types: 1- Numeric (Integer, Decimals) 2- String (Varchar, Char) 3- DateTime

I have few questions:

1- How the indexes are stored for different data types? For example if have Numeric data like (100, 101, 100, 900, 700) & string data like (AAA,BBB,CCC,AAA,ABC) how the numericcolumn & stringcolumn index will store this data on disk?

2- Is there any different between the retrieval of a Numeric & String indexes? For example if i try the SELECT statements on numericIndexed column & on sringIndexes columns how they are retrieved?

3- Is the indexes are stored different by SQL Server & Oracle? OR they use the same logic?
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: