Need advice on this long SQL query

Jean-Philippe_Martin

Hi, I created a SQL that gives a list of active users and their last action in Livelink if there was any. This query took half an hour to execute when no users were online. I wonder if I could do something different to make it more efficient. Thanks. select ku.name, ku.firstname, ku.lastname, kg.name groupe, to_char(ad, 'YYYY-MM-DD HH24:MI') lastaction from ( select performerid, max(auditdate) ad from dauditnew group by performerid ) da right join kuaf ku on performerid = ku.id left join kuaf kg on ku.groupid = kg.id where ku.deleted = 0 and ku.groupid not in (1001, 971153) order by ad desc, kg.name, ku.lastname, ku.firstnameGroups 971153 is disconnected users. I have included an explain plan. Thank you