Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    6

    Unanswered: How to speed up Querying a a huge table

    hi
    if any one help How to speed up Querying a a huge table in oracle ?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Read the Performance tuning guide

    Post the DDL of the table
    Post the SQL of the query
    Post the execution plan

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    define "huge"
    is huge = # of rows?
    is huge = size of table?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Dec 2007
    Posts
    253
    Quote Originally Posted by ramamoorthy
    hi
    if any one help How to speed up Querying a a huge table in oracle ?
    Buy a bigger server.

  5. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    the fastest query is the one that does not run
    Dave

Posting Permissions

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