Speeding up ORACLE queries .. HELP

From: Nicholas Kitchener <nkitchen_at_axion.bt.co.uk>
Date: 11 Aug 1994 08:16:01 GMT
Message-ID: <32cmo1$b24_at_pheidippides.axion.bt.co.uk>

As a student just in placement, I have a project to complete.

My problem is to do with SQLplus (ORACLE 7) at speeding up SQL queries, the general jist of the set of SQL queries is

WHERE ch_uid IN (SELECT ch_uid FROM pib_CR)

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

CREATE INDEX pib_icr ON pib_CR (ch_uid)

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

If you have any thoughts Email me..

Thanks in advance,

Nick. Received on Thu Aug 11 1994 - 10:16:01 CEST

This message: [ Message body ]
Next message: Mahesh Vallampati: "Re: Speeding up ORACLE queries .. HELP"
Previous message: Chris Regan: "Southern Connecticut Oracle Opportunities"
Next in thread: Mahesh Vallampati: "Re: Speeding up ORACLE queries .. HELP"
Reply: Mahesh Vallampati: "Re: Speeding up ORACLE queries .. HELP"
Reply: Anton Dischner: "Re: Speeding up ORACLE queries .. HELP"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message