Home / CSE MCQs / SQL Server MCQs :: Discussion

Discussion :: SQL Server MCQs

  1. Point out the correct statement :
  2. A.
    HierarchyID data type maps the data as a hashmap, so when traversing the binary tree structure
    B.
    In real scenarios, you always need to create indexes using HierarchyID data type
    C.
    In HierarchyID, we create indexes in order to make the traversal efficient
    D.
    None of the mentioned

    View Answer

    Workspace

    Answer : Option C

    Explanation :

    In order to make the query execution efficient, we create indexes.


Be The First To Comment