Re: Speeding up ORACLE queries .. HELP

Hi Nick,

i am not shure my hint does what you want but you should try:

... from table_name a, pib_CR b where a.ch_UID = b.ch_UID;

together with indexes this should fly.

Best regards,

Toni

In article <32cmo1$b24_at_pheidippides.axion.bt.co.uk>, nkitchen_at_axion.bt.co.uk (Nicholas Kitchener) wrote:

> 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.

+--------------------------------------------------------------------+
| Anton Dischner, DBA and system-programmer    Phone: +49 89 70953202|
| Institut fuer Klinische Chemie               Fax  : +49 89 70958888|
| Klinikum Grosshadern                         Home : +49 89 6254060 |
| Ludwig Maximilians Universitaet Muenchen     Handy: +49 172 8388880|
| 81366 Muenchen                                                     |
| Marchioninistr. 15                                                 |
| Germany                          Mail: dischner_at_med.uni-muenchen.de|
 +--------------------------------------------------------------------+