Tag Archives: Index

MIN , MAX and INDEX Access in Oracle.

All Entries in Index are stored as sorted either in ascending or descending order. If we need MIN or MAX for any column being indexed, its should be easier for oracle to fetch same as both would be at index … Continue reading

Rate this:

Posted in Oracle Internal, Oracle Performance | Tagged , , , , | Leave a comment

#SQLSERVERLearning : Does Unique Index Stored NULL Values in Index?

All my blogs with #SQLSERVERLearning are intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for any Oracle guy also working with SQL Server. All finding or Observations with SQL Server … Continue reading

Rate this:

Posted in Oracle Internal, SQL Server Learning | Tagged , , , , , | Leave a comment

INDEX Access Path and NULL Data in Oracle.

When started my learning with oracle, had lots of confusion with Btree index and NULL data correlation. Someone says index does not store NULL.. But says composite index store NULL.. Someone says when you are fetching only indexed column, it … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , | 1 Comment