Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can You Make A Non Indexed Field Indexed

user12296489Jan 8 2010 — edited Jan 9 2010
I am using PL/SQL to import data from a datawarehouse. I need to link one of the colums in tables A to another column in Table B. The column is indexed in table A, but it is not indexed in Table B. As a result, since there are many many records, it is very slow in pulling the data. Figured if both were indexed this would be sped up..

I have no direct control over the tables in this datawarehouse. i just connect to the DW and query the tables..Is there anyway to tell PL/SQL to index the non-indexed field I have to link to, via perhaps a function or some other way. I wouldn't think this is possible, but am fairly new to this sort of thing, so thought I might double check..

Thanks for any assistance..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2010
Added on Jan 8 2010
6 comments
1,753 views