Thank you very much Tomas!The reference to the _DB field with the objkey was the solution! Speed is now within the expected range of 0.1 seconds for a bigger quote!
Hi Thomas,I have just seen your second comment. Yes, it is a reference. I will change the query to CF$_C_RELATED_SQ_DB and let you know the result later today!Thanks!
Hi ThomasHere the description of the table SC_SERVICE_CONTRACT_CFT. There are two indexes.And here what IFS shows: What exactly do you mean with definition of the field? The CF in IFS itself? Does this information help with the finding of a possible solution? Thank you in advance for your input!
Any other suggestions out ther in the community on how to speed up my custom field? Any help would be greatly appreciated! I am open to try anything that comes to your mind!Thanks!
Yes, the C_Related_SQ is already indexed.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.