This is my explain analyze output.
SELECT
A."codeNumber",
A."englishName"
FROM (
PUBLIC."ledgerGroupList" A
/* PUBLIC."ledgerGroupList".tableScan */
/* scanCount: 88 */
LEFT OUTER JOIN PUBLIC."ledgerGroupList" "ledgerGroupNoCList"
/* PUBLIC.PRIMARY_KEY_EE: "nameNo" = A."ledgerGroupNoC" */
ON A."ledgerGroupNoC" = ledgerGroupNoCList."nameNo"
/* scanCount: 173 */
)
WHERE ((ledgerGroupNoCList."englishName" = 'Cash In Hands')
AND ((A."lft" > ledgerGroupNoCList."lft")
AND (A."rgt" < ledgerGroupNoCList."rgt")))
OR ((A."type1" = 'L')
AND ((ledgerGroupNoCList."englishName" = 'Bank Accounts')
AND ((A."lft" > ledgerGroupNoCList."lft")
AND (A."rgt" < ledgerGroupNoCList."rgt"))))
ORDER BY 2
/*
reads: 90
*/
On Saturday, October 31, 2015 at 5:43:12 AM UTC-7, Noel Grandin wrote:
>
> what does EXPLAIN ANALYZE on the query say?
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
