sql index performance tuning

execution plan in oracle

What is Explain Plan in Oracle | Simple Explain

Explain plan in Oracle is the sequence of operations for a statement that is chosen by the Oracle optimizer. This is the flow of execution of a statement. The execution ...

Asiri Gunasena

June 17, 2024

oracle index full scan

2 Reasons to Why Oracle Index Full Scan

An Oracle index full scan is Oracle start read block from ROOT and then navigating to the down branch until find the leaf block on the left side. Move to ...

Asiri Gunasena

May 27, 2024

Sql Index usage

Poor SQL Index Usage including Good Examples

When making performance improvements in your database SQL Index Usage is one of the most valuable and essential features. SQL Indexes are used to retrieve data from databases by reducing ...

Asiri Gunasena

March 13, 2023

ennicode

Address: 89/1 Rabbegamuwa, Handessa, Kandy, Central, Sri Lanka

Email to: Primary: [email protected]

Services

Company Websites

Support and Configuration work

Banners, Covers, and Post

Web Development & Configurations

Content Writing and Marketing

Resources

Developer Center

Contact