<div>
&gt;&gt; reindex the whole table<br />
YOu mean create another index on the table? Or re-build the index.<br />
<br />
However, there are no ways to index a subset of your records. <br />
<br />
Is your table partitioned? If so, you can re-build the local indexes on specific partitions.
</div>


>> reindex the whole table
YOu mean create another index on the table? Or re-build the index.

However, there are no ways to index a subset of your records.

Is your table partitioned? If so, you can re-build the local indexes on specific partitions.

<div>
Is your data from table updated, deleted frequently? If not, then I suggest you create Index Organized table and move data in new table. <br />

</div>


Is your data from table updated, deleted frequently? If not, then I suggest you create Index Organized table and move data in new table.


<div>
Oracle does not allow us to build an index on only part of table's records. &nbsp;You can only create an index on the entire table. &nbsp;Yes, if you have an index that is already partitioned, you can move or rebuild individual partitions. &nbsp;But you cannot create just one partition at a time of a new index.<br />
<br />
No, there is no way to rebuild or move existing indexes without affecting performance. &nbsp;And no, there is no way to create a new index without affecting performance.<br />
<br />
What is the problem or error that prevents you from re-indexing the table now?
</div>


Oracle does not allow us to build an index on only part of table's records.  You can only create an index on the entire table.  Yes, if you have an index that is already partitioned, you can move or rebuild individual partitions.  But you cannot create just one partition at a time of a new index.

No, there is no way to rebuild or move existing indexes without affecting performance.  And no, there is no way to create a new index without affecting performance.

What is the problem or error that prevents you from re-indexing the table now?

<div>
<div class="content wysiwyg-content">
I have a table of 20 million records. i want to reindex the whole table. i can't reindex in one shot. i am planning to do that by reindexing every thousands of records. Is there any other way which will not affect the performance?
</div>
</div>


I have a table of 20 million records. i want to reindex the whole table. i can't reindex in one shot. i am planning to do that by reindexing every thousands of records. Is there any other way which will not affect the performance?

reindexing in oracle 10g

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.