Re: Indexing Tables

Hi,
 In addition to the indexes u created , u will also have the primary key index which will already be there.
The number of indexes you will need, will depend on the kind of queries that will be fired on this table.
At times too many indexes will mar the performance.

Don't foreign key constraints, create indexes like primary key constraint does ?? ( SOME GURUS ..PLEASE RESPOND..), i suppose it should.

Avinash

Viswanatha Thalakola wrote:
>
> Hello,
>
> I am designing an Oracle database and i am slightly puzzled about
> the fields I should be indexing.
>
> For example in the following table,
>
> table t_inventory_items
>
> This table will become a large table, data will be stored for atleast
> ten years before it is
> cleaned up.
>
> I have indexed transfer_orderid, no_of_units
>
> I would like to know if the other foreign keys are good choices for
> indexing when the table is going to be
> large.
>
> Thanks in advance
>
> Reddy
Received on Thu Jan 08 1998 - 00:00:00 CET