>OTIS WROTE:
>Hi,
>
>I've created a bunch of tables without specifying "organized index"
>clause with CREATE TABLE. I didn't know I would need that in order to
>create indexes on those tables.
>Well, I need to create indexes on those tables now and I'm wondering if
>it can be done or is it too late?
>
>I tried making tables "organized index" from Sql*plus:
> ALTER TABLE foo MOVE PCTTHRESHOLD 50;
>
>This didn't work. Is this the right syntax?
>Is there any way to make them "organized index"?
>
>Also, a related question:
>I've noticed that if I do:
> SELECT non_PK_column FROM foo WHERE PK_column=1;
>
>The PK index is not being used, but if I do:
> SELECT a PK_column FROM foo WHERE PK_column=1;
>
>then it is.
>Is this normal?
>I'm using WHERE pk_column=1 in both cases so I would think that the
>index would be used both times.
>
>Thanks,
>
>Otis
>
>
Hi Otis
CREATE INDEX idx_name ON table_name(column_name)
hth
s
Received on Thu Apr 13 2000 - 00:00:00 CDT
