I have create a linked table to an Oracle server in SQL Server Enterprise Manager. It connects fine. But the table has 18 millions of rows. So if I query from SQL Server, it takes a lot of time to do that. Is there any way to use or retrieve the indexes of the Oracle table?
In Enterprise Manager -> Linked Servers I see that I have retrieved only tables and views, but no indexes.
I refer to the Oracle table in this way:
select * from LINKEDSERVERNAME..OWNER.TABLE where field01='xx' and field02='yy'