Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
indexes
This is a discussion on indexes within the Oracle forums, part of the Databases category; Is There any performance issue if i drop redundant indexes ?...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
11-20-2008
|
|||
|
|||
|
indexes
Is There any performance issue if i drop redundant indexes ?
__________________
Sireesha 
|
| Sponsored Links |
|
11-20-2008
|
|||
|
|||
|
Re: indexes
When we say redundant indexes, it simply means the indexes never used by Oracle. since those were never used , there won't be any performance issue. Removing those might remove some overhead as well.
|
|
11-20-2008
|
|||
|
|||
|
Re: indexes
One more point I would like to add is that keep rebuilding your indexes on the table on which lots of DML operations are performed. You will always be safe from any performance issue
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Bit Mapped Indexes | Lokesh M | Data Warehousing | 0 | 02-07-2008 05:00 AM |
| rebuild all the indexes of the table or schema | pande.dhiraj | Oracle | 1 | 11-20-2007 03:59 AM |
| Query on indexes in oracle | vinayhc | Oracle | 2 | 11-20-2007 03:10 AM |
| Rebuilding of indexes | vinayhc | Oracle | 7 | 11-19-2007 10:21 AM |
| How does indexes function? | Lokesh M | SQL | 10 | 10-07-2007 02:13 PM |
All times are GMT -4. The time now is 10:33 AM.
