General discussion

  • Creator
    Topic
  • #2280308

    Challenging Performance Tuning

    Locked

    by tekichan ·

    One of my application involves searching data from 1,000,000 records in an Oracle 8i database. The select statement involves sub-query and group-by. It may stores more records than that, say 1,000,000,000 records in coming days.

    However, it halted. I tried to copy the SELECT statement into SQL*PLUS to run. Halted again!

    This meant I had to improve my DBMS’ performance to solve this problem.

    Now I find the following solutions;
    1. Indexing
    2. Make a table to store the result of SELECT statement
    3. Database Aggregation

    What do you think?

All Comments