DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: select question

  1. #1
    Join Date
    Oct 2000


    I am running a data warehouse using Oracle 8.1.6
    Assuming that I have 80 gig of data
    in one table. I have a very fine tuned
    select statement that returns the result I want in
    30 minutes from one particular select statement.

    If the data in the table grows 2 folds to 160 gig.
    Do you think that that same query will take 60
    minutes to return the output?
    NOTE: The query is very fine tuned in the best
    possible way. And the select statement has not
    being altered/changed.

  2. #2
    Join Date
    Nov 2000
    Baltimore, MD USA
    It depends on way too many variables to guess.

    If it is a simple tablescan, then probably

    If it is a simple index lookup, then probably not.

    If it is a join of multiple tables with tables scans and indexes and has joins and nested loops where some percentage of the blocks might be cached, then flip a coin and make a guess.

    - Chris

    Also, I am moving this thread to the Developer's forum.
    Christopher R. Long
    But that's just my opinion. I could be wrong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.