Hi, pls tell me the types of oracle index in detail. consider this situation, if a select query without any where clause takes much time to get data,then we will create index for that table. now again run the same select query. this time, whether the query takes much time again or will it work fast? whether the index is used for a select query execution or not? how we can confirm that whether the oracle using the index normally?