hql1: delete Revision r where exists (select f from File f where f.fileState='2' and f.uid=r.file.uid)
等同于
hql2: delete Revision r where r.uid in (select f from File f where f.fileState='2' )
表Revision(小表),表File(大表) hql1效率高
表Revision(大表),表File(小表) hql2效率低