Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

question on Open text query on DTreeACL

Status
Not open for further replies.
DBA_OT

DBA_OT

Technical User
Aug 17, 2020
1
AU
hi

a query similar to below is running on our SQL database very often (some times up to 10 times a minute) and it's returning somewhere between 300K -900K records in various runs.

Has anyone seen this query and is it normal for it to run this often? thin many records? any help is really appriciated.
we are on SQL 2016

SELECT DataID,Permissions FROM DTreeACL
WHERE DataID IN (SELECT DataID FROM DTree WHERE ParentID=@P1)
AND (RightID IN ( SELECT KUAFRightsListNew.RLRightID FROM KUAFRightsListNew WHERE KUAFRightsListNew.RLID=XXXXXXXXXX AND KUAFRightsListNew.RLProxyType=0 ) ) ORDER BY DataID
 
Status
Not open for further replies.

Similar threads

sherriffot
  • Locked
  • Question
Error creating index on EDOCS Server Manager
Replies
0
Views
497
sherriffot
sherriffot
MRefaii
  • Locked
  • Question
DTreeACL Table - Permissions Column
Replies
2
Views
496
ggriffit
ggriffit
oscript
  • Locked
  • Question
Opentext Content Server 22.3 - Appearances
Replies
1
Views
779
ggriffit
ggriffit
sherriffot
  • Locked
  • Question
Viewing by BravaServer does not work on SmartView - Opentext livelink
Replies
3
Views
771
Ekta Singh
Ekta Singh
DWMe
  • Locked
  • Question
Why should you Learn Opentext Course?
Replies
0
Views
548
DWMe
DWMe

Part and Inventory Search

Sponsor

Back
Top