Indexing an Oracle Table

C

CCheatham

I have an Oracle table that I am trying to query off of, and it takes
way too long. There are no indexes or primary keys in this table, with
millions of rows. I have a local table with an "INVOICE" number as it's
primary and indexed field. What kind of SQL statement can I use to
retrieve the information faster, meaning, how do I have the Oracle
table indexed so this query won't take an hour to run?
 
J

Jeff Boyce

If the source of the data is in Oracle, the Oracle source table(s) have to
be indexed. You'll have to have the Oracle DBA index the fields on which
you are selecting, sorting or joining.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Record into Oracle Table 1
ODBC -- update on a linked table [table name] failed 1
Equivalent of the Oracle In (select *) 7
Joins and Query Speed 1
Pass through query to oracle db 2
Pass Through Query using Local Access Table 1
Append Query w/sequence.NextVal to Oracle DB? 2
Poor performance running queries with tables linked to Oracle Back 4

Top