Re: Oracle 7.2 on NT 4.0 SP3 Performance Problem

Matthias Gresz wrote:

> Hi,
>
> if you CBO then you should analyze your table to get actual statistics.
> Using indexes on DOORNUM would also increase the performance. Nnd LBNL
> try
>
> SELECT COUNT(B.DOORNUM)
> FROM BASIC B, DOOR D
> WHERE B.DOORNUM=D.DOORNUM;
>

Forgot to metion that. The column DOORNUM is the primary key of Table BASIC and I created an index for DOORNUM in Table Door, too. Received on Fri May 15 1998 - 19:54:20 CDT