Storage Index in Oracle Exadata

Hi,

I will explain Storage Index which is magic feature of Oracle Exadata in this article.

 

Before this post, If you don’t know What is the Exadata and want to learn, you can read following Exadata Tutorials.

 

Storage indexes, one of the unique features of Exadata, is a feature that prevents excessive physical I/O in the Cell Server. Storage indexes are a structure that stores up to 8 column data to avoid making unnecessary I/O on memory.

 

Each disk in each Cell Server has a storage space of 1MB which holds an index ( pointer, location info ) where all the data stored in the storage is written. The storage index is the objects that keep the distribution map of the data on the disk created automatically in memory for the related SQL.

Storage indexes are completely memory based, do not keep physical space, and these are lost when Cell Server is restarted. After starting the cell server, Exadata will create them according to running queries.

 

The Storage Index is the part of Smart Scan because it helps the Client send only the requested data in the query.

To enable storage index for any query,  it must meet the following requirements.

 

  • Queries can use Storage index that are using Smart Scan.
  • Where condition like , where id > 200
  • Storage index can use  ” =, <, >, BETWEEN, IN, IS NULL, IS NOT NULL, >=, <= “operators.
  • Storage indexes can support number,date,varchar2 data type.
  • Storage indexes can not support nls data type.

 

 

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *