A Sort Problem ( ADABAS fatser than Oracle )

From: Andreas Walter <a.walter_at_dr-staedtler.de>
Date: 1998/04/02
Message-ID: <6g074c$kj8$1@news.nacamar.de>#1/1

Hi,
we have Oracle Version 8.0.4.0.0 on an NT. I have the follwing table

Create Table Orte (

    Land varchar(3) not null,
    Postleitzahl varchar(10) not null,     Ort varchar (25 ) not null,
    Ortsteil varchar(30) )

and an Index

create Index I_Land

on Orte ( Land , Postleitzahl, Ort ).

When I made the follwing SQL Statment on a client " Select * from orte " I have very quick an answer. But when I made the follwing Statment " Select * from orte order by land, postleitzahl, ort" I must wait some seconds.

In SQL-Plus I saw that the last Statment cuased an sort on disk. But I don't
unterstand why, because I have an perfect fit Index. Have anybody an idea why?
And Have anybody an idea to tune the server that I don't need an index.

I try the same things in an ADABAS 6 enviroment. And the answer was quicker. I find it a little bit strange because anybody told me that Oracle is so much better than ADABAS.

thanks in advance

Andreas Received on Thu Apr 02 1998 - 00:00:00 CST