Regular relational indexes on the unitID columns of both tables as well as on the manager column in the unit table can help speed up the embedded SQL query.
两个表的unitID列上的常规关系索引以及unit 表的manager列上的常规关系索引有助于提高嵌入式SQL查询的速度。
The unitID column identifies the unit containing the department (a unit may contain multiple departments), and the deptdoc column contains an XML document listing the employees in the department.
unitid列标识包含部门的单位(一个单位可能包含多个部门)，deptdoc列包含一个列出部门中的员工的XML文档。
The unitID column identifies the unit containing the department (a unit may contain multiple departments), and the deptdoc column contains an XML document listing the employees in the department.
unitid列标识包含部门的单位(一个单位可能包含多个部门)，deptdoc列包含一个列出部门中的员工的XML文档。
应用推荐