The following are few tips for cursor optimization:
Indexes improve query performance but it slows down data modification operations.
Indexes consume disk space.
The Index tuning wizard can be used to improve the performance of queries and databases. It uses the following measures to do so:
Index tuning is part of database tuning for selecting and creating indexes. The index tuning goal is to reduce the query processing time. Potential use of indexes in dynamic environments with several ad-hoc queries in advance is a difficult task. Index tuning involves the queries based on indexes and the indexes are created automatically on-the-fly. No explicit actions are needed by the database users for index tuning.