I have lots of join in select statement and the tables are contain large amount of data.
Which index should i use for increase performance?
Kindly share your views.
Thanks in advance.
No Comments Posted for this Article.
SAP Oracle Missing Indexes
Identify the missing indexes in DB02 (which will reduce the performance without proper indexes) Goto DB02 > Diagnostics > Missing Tables and Index Check the objects that are missing ...
Oracle Performance Interview Question and Answer
1. Can I use this FAQ to solve all Oracle performance problems?Analyzing database performance is a complex subject. This FAQ does not claim to provide the solution for all performance problems...
Oracle Index Organized Tables (IOTs)
1. What is an Index Organized Table (IOT)?An Index Organized Table (IOT) is a table that is sorted internally as an index.Other database systems such as MAXDB or DB2 use IOTs by default, whereas on...