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.
There are two tables involved. Customer and Address.
And No Condition.
ASKED:
May 6, 2005 11:45 AM GMT
UPDATED:
May 6, 2005 11:59:17 AM GMT
RELATED QUESTIONS
- Improving the initial speed of a SQL query
- Flush the query plan from the RAM.
- SQL Express 2005 query times lagging
- How do I modify the value returned from current(time)
- Query/400 replacement needed
- User Profiles
- Query Criteria
- Date Time SQL Selection Criteria
- Replacement of CROSS APPLY statement
- HI GUYS - OPTIMIZATION
Answer Wiki:
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
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
0 pts.
To see other answers submitted to the Answer Wiki View Answer History.
