这条SQL还能优化吗？求帮助

Question

Select Nvl(Max(a.记录状态), 0) As 状态, a.物品id As 物品id
From 物品使用记录 a,
(Select Extractvalue(Column_Value, '/ROW/单据号') As No, Extractvalue(Column_Value, '/ROW/库房ID') As 库房id
From Table(Xmlsequence(Extract(Xmltype(:x_数据), '/ROWSET/ROW')))) g
Where a.No = g.No And a.库房id = g.库房id And a.记录性质 = 2 And a.公司id = :公司id
Group By a.物品id

Answer 1

可以，将子查询放入临时表，对where的字段加上索引，用空间换时间。