|
-
our two cents.....
Try this out....
Original sql scrip.
SELECT a.dt_tm, b.data_blob from audit_event a, audit_data_blob b WHERE a.evnt_id = b.evnt_id and a.serv_typ_id =5399 and a.dt_tm > sysdate - 1 ORDER BY a.dt_tm
Suggested
SELECT a.dt_tm, b.data_blob
FROM audit_event a, t_data_blob b
WHERE a.serv_typ_id = 5399
AND a.dt_tm > sysdate - 1
AND b.evnt_id = a.evnt_id
ORDER BY a.dt_tm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote