select question 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