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 |
|
bvanyangu
Starting Member
20 Posts |
 Posted - 2014-10-20 : 11:56:45
|
| what is clustered index A and B. I don't see anything on google regarding this interview question. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-20 : 12:02:53
|
| "A and B"? I don't understand what that is referring to. A clustered index is the physical sort of the data on disk. You can have one clustered index per table.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
bvanyangu
Starting Member
20 Posts |
Posted - 2014-10-20 : 15:25:15
|
quote:
Originally posted by tkizer
"A and B"? I don't understand what that is referring to. A clustered index is the physical sort of the data on disk. You can have one clustered index per table.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
|
|
|
|
bvanyangu
Starting Member
20 Posts |
Posted - 2014-10-20 : 15:27:39
|
I failed to understand that too. I know about what a clustered index is, so i thot maybe the question refered to Index pages.quote:
Originally posted by bvanyangu
quote:
Originally posted by tkizer
"A and B"? I don't understand what that is referring to. A clustered index is the physical sort of the data on disk. You can have one clustered index per table.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-20 : 15:29:48
|
| I suspect it is just the columns in the index. In that case, it is sorted by A,B on disk.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Clustered Indexes