Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
13 replies
Subscribers
9 subscribers
Views
4984 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
I would like to populate a table on a record view that reads its data from an Or
mohamedb
over 9 years ago
I would like to populate a table on a record view that reads its data from an Oracle VIEW. I use the a!queryEntity to query the data. The query works fine when reading from existing tables in DB; but gives the attached error when I apply it on the view.
When I try to query the Oracle View from Oracle developer, I realize it really takes a long time to obtain the results. So, most likely it is a time out issue.
Do you recommend any optimizations to Oracle View to better integrate with Appian?
OriginalPostID-211908
OriginalPostID-211908
Discussion posts and replies are publicly visible
Parents
0
Tim
Certified Lead Developer
over 9 years ago
Check the underlying source tables and consider adding an index to the field used in your query filter. Also examine the explain plan for the query with your DBA.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Tim
Certified Lead Developer
over 9 years ago
Check the underlying source tables and consider adding an index to the field used in your query filter. Also examine the explain plan for the query with your DBA.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data