APEX 19.2 and DBLINK - Indexes [message #679385] |
Thu, 27 February 2020 03:26 |
|
AdrianWard
Messages: 21 Registered: September 2019
|
Junior Member |
|
|
Hi
I finally gave up trying to install 19.2 on my 11g Oracle database and created a brand new server to host APEX19.2, using DBLINKS to connect to the Oracle 11g database.
I moved all my APEX specific tables, PL/SQL views and triggers etc directly into APEX (originally created on 11g DB), however I still access some Oracle tables in queries (AR tables mainly).
I have a load of indexes between my APEX tables and the Oracle AR tables that are currently created on the Oracle DB. Would these be better created within APEX or would they work better left in Oracle?
Thanks in advance
Adrian
|
|
|