Oracle 9i Query Time
Home > IT Answers > Database > Oracle 9i Query Time
jummadaay
0 pts.
0
Q:
Oracle 9i Query Time
Database issues, Oracle, Database Management Systems, Very Large Databases, Total size of the database, s, in use in organization
What would be an expected time to run a query that will extract 1.4 million records?

There are two tables involved. Customer and Address.
And No Condition.
ASKED: May 6 2005  11:45 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
r937
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
no conditions? there had better be a join condition!!

what time to run it? depends on the machine it's running on, whether there is anything else running on it at the same time, how much memory the machine has, and so on

that said, i'm afraid i cannot help you any further, because i'm not a DBA

you really need your DBA in your organization to answer this question
Last Answered: May 6 2005  11:59 AM GMT by r937   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0