题目内容
Teacher(Tno,Tname,Tage,Taex);Department(Dno,Dname,Tno);Work(Tno,Dno,Year,Salary)假设Teacher的Tno属性,Department的Dno属性及Work的Year属性上有B+树索引,说明下列查询语句的-种较有的处理方法。(1)select*from teacher where Tsex=‘女’(2)Select*from department where Dno<301(3)Select*from work where Year<>2000(4)Select*from work where year>2000and salary<5000(5)Select*from work where year <2000or salary<5000
查看答案
搜索结果不匹配?点我反馈