Announcement Announcement Module
Collapse
No announcement yet.
Help in HQL Optimization Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help in HQL Optimization

    au.xxx.xxx.domain.yyyy as generatedAlias0

    inner join generatedAlias0.aaa as generatedAlias1
    inner join generatedAlias0.bbb as generatedAlias2

    where

    ( ( generatedAlias1.id=aram0 )

    and

    ( generatedAlias0.status=aram1 ) )

    and ( generatedAlias0.status<>aram2 ) order by generatedAlias2.name asc, time: 32452ms, rows: 381


    Can you help me optimize this SQL from my page?
Working...
X