Re: Speeding up ORACLE queries .. HELP

From: Carlos Netto <Carlos.Netto_at_ax.apc.org>
Date: Fri, 12 Aug 94 22:46:00 -0300
Message-ID: <2aa.551.846%mpcbbs_at_ax.apc.org>

On 11 Aug 94 05:16am, Nicholas Kitchener wrote to ALL:

 NK> Newsgroup: comp.databases.oracle
 NK> Organization: BT Laboratories

 NK>  As a student just in placement, I have a project to complete.
 NK>  
 NK>  My problem is to do with SQLplus (ORACLE 7) at speeding up SQL queries,
 NK>  the general jist of the set of SQL queries is

             FROM  ??????
                   ^^^^^^
 NK>         WHERE ch_uid IN (SELECT ch_uid FROM pib_CR)
                   ^^^^^^

 NK> I have created indices for the three tables I have created by :

 NK> CREATE INDEX pib_icr ON pib_CR (ch_uid)  

        You need to create a index on column ch_uid from the table ?????
        (see over).

 NK> The main point of my question is there a method for speeding up big  NK> multi table SQL queries ??

---

| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ax.apc.org |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |

|---------------------------------------------------------------------------|


|  Softex 2000 member             | Brazil, Sao Paulo state, Campinas city  |


=============================================================================

• Evaluation copy of Silver Xpress. Day # 49 --- via Silver Xpress V4.01P [NR]

  ---

Internet: Carlos.Netto_at_ax.apc.org (Carlos Netto) This message was processed by RAuucp from Merlin Systems Inc.

---

Received on Sat Aug 13 1994 - 03:46:00 CEST