db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Queries satisfiable from indexes
Date Tue, 20 Mar 2007 20:12:17 GMT
> Can Derby do this, or does it load the rows regardless?  

Yes, Derby can definitely do this. Here's more info:
http://db.apache.org/derby/docs/dev/tuning/ctunperf10679.html
http://db.apache.org/derby/docs/dev/tuning/ctundepth23033.html#ctundepth23033

In the case of the query plan you presented, it seems
to me that Derby is in fact using the index, and not the
base table; that's what I believe this line is saying:

 > Index Scan ResultSet for MAIL_ITEM using index I_MAIL_ITEM_TAGS_DATE

thanks,

bryan



Mime
View raw message