How Balanced Tree is implemented if there are more than one columns are involved?

thomaszhwang
thomaszhwang used Ask the Experts™
on
It's easy to understand the situation with one column, but what if two columns are involved?  Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
All SQL indexes are b-tree so 1,2,3 or more columns same thing. The difference is that only the first 2/3 will make a major impact in your queries similar to other db engines.

http://www.akadia.com/services/sqlsrv_data_structure.html

Author

Commented:
Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial