topic Re: Indexes in Application Development and Automation Discussions

Indexes

Former Member — Tue, 27 Mar 2007 06:48:34 GMT

how many indexes can be created for a table?

Former Member — Tue, 27 Mar 2007 06:49:30 GMT

HI,

We can create 9 Indexes for a Table

Regards

Sudheer

Former Member — Tue, 27 Mar 2007 06:52:22 GMT

tangirala,

There are two kinds of indexes. one is primary index and other one is secondary index.

primary index will be automatically created by the system.

but user has to define this secondary index.

Maximum of 15 secondary index is possible.(As per 21 days book).

but keep the secondary index as minimum as possible.

Regards...

Arun.

Reward points if useful.

Former Member — Tue, 27 Mar 2007 06:52:33 GMT

Per table u can create maximum 510 index.

for detail

Message was edited by:

Kalpana M