数据库实验：索引与复杂查询操作详解

/*在预算日期、结算日期和入账日期上分别建立索引*/
--create index 预算日期索引 on workproject(DBudge);
--create index 结算日期索引 on workproject(Budgettime);
--create index 入账日期索引 on workproject(Credittime);
--drop index workproject.预算日期索引,workproject.结算日期索引,workproject.入账日期索引;/*删除索引*/

--select *
--from workproject/*4-2-1*/
--where workproject.Dno='112201002'and DBudge>='2011-5-1'and DBudge<='2011-5-28';
--select *
--from workproject/*4-2-2*/
--where workproject.Dno='112201002'and Budgettime>='2011-5-1'and Budgettime<='2011-5-28';
--/**/

--select Dworkproject,Materialfee,Manfee,Shenbeifee,Otherfee
--from workproject/*4-2-3*/
--where workproject.Dno='112201002'and Budgettime>='2011-5-1'and Budgettime<='2011-5-28';
--/**/
--select Dworkproject,Creditamount,Creditpeople,Credittime
--from workproject/*4-2-4*/
--where workproject.Dno='112201002'and Credittime>='2011-5-1'and Credittime<='2011-5-28';
--select sum(MBudge) Total_MBudget
--from workproject/*4-2-5*/
--where workproject.Dno='112201002'and DBudge>='2011-5-1'and DBudge<='2011-5-28';
--select sum(Budgetfee) Total_Budgetfee
--from workproject/*4-2-6*/
--where workproject.Dno='112201002'and Budgettime>='2011-5-1'and Budgettime<='2011-5-28';
--select sum(Creditamount) Total_Creditamount
--from workproject/*4-2-7*/
--where workproject.Dno='112201002'and Credittime>='2011-5-1'and Credittime<='2011-5-28';