I'm new to Documentum and I am having some performance issues where some particular queries are taking a long time.
I am going through all our queries in our application and checking them to see how they perform and making changes where appropriate and have some best practice type of questions:
1. Should I generally always use the DB only (ENABLE NOFTDQL) for queries that have a where clause containing attribute values, either custom attributes or built in.
2. Similar question for using a "WHERE myattrib LIKE '%abc%'" I understand using a percent at the start of the string is very inefficient and will cause a full table scan. But would such queries be better run against the index server (if they are FTDQL compliant), ie using (ENABLE FTDQL)?
3. What is the difference between ENABLE TRY_FTDQL_FIRST and specifying no hint at all?
4. Is ENABLE TRY_FTDQL_FIRST potentially inefficient if I know that using the index server will be slower, or non FTDQL compliant
95% of the queries are not document content related. There is a single search function that uses the index server. Then there are a mixture of queries with some having TRY_FTDQL_FIRST hint added to try and fix the performance issues.
Regards
TJT
