I am bit late in the thread but still may be worth it to answer

- I use it always from the SQL Browser. 

I did had a post about it too on DC a week or two back, asking how relevant those plans and answers I got were that the plans are not super relevant, what matters most is the response time. 

Feedback : What I would love to have from these plans is also a suggestion, how you get in db2 / oracle etc telling us what indexes or improvements in query we can make to make the performance better. 

alternate plans - yes, i know it exists.  only when i feel the query is super slow, i actually go and take a look at it. not otherwise

if the alternate plan button was right there  next to show plan, it will be used more.  Infact all the sql optimization tools should be next to the query window on sql browser. that's where it belongs.

Good article and post.

If I understand it correctly, this is the server side of building rest service for CRUD activity.

Is there an article that explains the UI side of it?

What I be keen would be  Cache/IRIS independent UI solution connecting to this Rest Service.  So if cache was turned off and that service was routed to something else, it should still work.

Hi Henrique,

This looks really good.

Before I dive further into your post, may I ask just one or two simple questions

1. Is the only connection to cache here is the Rest Services ?

For eg. if I replace the cache rest url and replace it with another one.. which is sending exactly same data . will it work?

2. Do we need to install something on the system for the same ?

3.  Do your files have an extension of .html or something else?

4. Is it correct to say that there is no Angular or node.js involved??

Many thanks