additional indices have been added in r84580 with

The previous index:

create index DASH_NEWS_LINK_PERSON_ID_IDX on DASH_NEWS_LINK(PERSON_ID)

did not have impact on performance.

Drew has hence added another index on ITEM_ID, as shown below. We will see whether this one is effective:

DASH_NEWS_LINK_ITEM_ID_IDX on DASH_NEWS_LINK(ITEM_ID)

Drew has added the following index into ctload db:

create index DASH_NEWS_LINK_PERSON_ID_IDX on DASH_NEWS_LINK(PERSON_ID) tablespace ctools_indexes;

This is to help with the following query:

2g9yy1dj6tns9

select person.sakai_id from dash_person person join dash_news_link link on link.
person_id=person.id join dash_news_item item on link.item_id=item.id where item.
entity_ref=:1

We are waiting for the ctload AWR report stats to show the effectiveness of this index.

On the other hand, we may want to do similar things to help with query "select person.sakai_id from dash_person person join dash_calendar_link link on link.person_id=person.id join dash_calendar_item item on link.item_id=item.id where item.entity_ref=? ". But since it has not poped up as top queries on the AWR report, we do not plan to add index as of now.

Please add following to (at least) Oracle conversion:

create index DASH_CALENDAR_LINK_ITEM_ID_IDX on DASH_CALENDAR_LINK(item_id) tablespace ctools_indexes

We should also ask Drew if it makes sense to have a NEWS_LINK index

conversion scripts have been added for Oracle, MySQL, and HSQL.