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文档。
应用推荐