Interesting. that looks reasonable.
What does the Derby plan look like?
http://stackoverflow.com/questions/5981406/apache-derby-explain-select
On 2012-07-11 10:07, Bartosz Skorupa wrote:
For
EXPLAIN ANALYZE SELECT logentry.date , logentry.nanotime FROM
logentry, log_categories
WHERE logentry.category = log_categories.id <http://log_categories.id>
AND logentry.nanotime >= 10089487311026
AND logentry.nanotime <= 10090280303361
ORDER BY 2 ASC NULLS LAST LIMIT 165 OFFSET 0;
i got
SELECT
LOGENTRY.DATE,
LOGENTRY.NANOTIME
FROM PUBLIC.LOG_CATEGORIES
/* PUBLIC.LOG_CATEGORIES.tableScan */
/* scanCount: 9 */
INNER JOIN PUBLIC.LOGENTRY
/* PUBLIC.CONSTRAINT_INDEX_A6: CATEGORY = LOG_CATEGORIES.ID
<http://LOG_CATEGORIES.ID> */
ON 1=1
/* scanCount: 2244038 */
WHERE (LOGENTRY.NANOTIME <= 10090280303361)
AND ((LOGENTRY.NANOTIME >= 10089487311026)
AND (LOGENTRY.CATEGORY = LOG_CATEGORIES.ID
<http://LOG_CATEGORIES.ID>))
ORDER BY 2 NULLS LAST
LIMIT 165 OFFSET 0
/*
total: 165276
LOGENTRY.CONSTRAINT_INDEX_A6 read: 10216 (6%)
LOGENTRY.LOGENTRY_DATA read: 155060 (93%)
*/
and for
EXPLAIN SELECT logentry.date , logentry.nanotime FROM logentry,
log_categories
WHERE logentry.category = log_categories.id <http://log_categories.id>
AND logentry.nanotime >= 10089487311026
AND logentry.nanotime <= 10090280303361
ORDER BY 2 ASC NULLS LAST LIMIT 165 OFFSET 0;
i got
SELECT
LOGENTRY.DATE,
LOGENTRY.NANOTIME
FROM PUBLIC.LOG_CATEGORIES
/* PUBLIC.LOG_CATEGORIES.tableScan */
INNER JOIN PUBLIC.LOGENTRY
/* PUBLIC.CONSTRAINT_INDEX_A6: CATEGORY = LOG_CATEGORIES.ID
<http://LOG_CATEGORIES.ID> */
ON 1=1
WHERE (LOGENTRY.NANOTIME <= 10090280303361)
AND ((LOGENTRY.NANOTIME >= 10089487311026)
AND (LOGENTRY.CATEGORY = LOG_CATEGORIES.ID
<http://LOG_CATEGORIES.ID>))
ORDER BY 2 NULLS LAST
LIMIT 165 OFFSET 0
Pozdrawiam
Bartosz Skorupa
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
