Could any one tell me, how the index  works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001       ABC            20

002       AAA            21

003       ABB            23

004       BBB           20

005       BDF           24

006        EEE          22

Will SQL Engine directly hit the "005" record using ^EMPLOYEEI global, if so h

When I was searching for the ideas to migrate IRIS DB to Oracle, I could find a tool called "ESF Data Migration tools" over internet with easy steps.

Can we use them to migrate?

Link for your reference

https://www.dbsofts.com/articles/cache_to_oracle/
 

Thanks in advance

Are we allowed to delete _SYSTEM user of an Intersystems IRIS, If so,how can we do that?

What is Global mirroring and its purpose?

Could you please tell me, How do we create a global that can be shared by all namespaces?

Difference between %ResultSet.SQL and %SQL.Statement

Can anyone please explain that how can we apply locks on objects and use them with examples.

how the deferred locks works?

Can any one explain about types of inbound and outbound adapters along with its methods?

Thanks in advance

How to increase the performance of the production when getting multiple messages from various Healthcare organizations

what is the purpose of default settings in System management portal?

In Index types, I can see "Extent Index", Please tell me in detail about it

Can any one tell me the difference between %KillExtent and %DeleteExtent with example