Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • SQL_PROFILE – I explaination Oracle
  • Generating XML from SQLPLUS Oracle
  • tblwopk.sql tablewopk.sql Oracle
  • Jai Shree Ram Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • This is from Temi Oracle
  • Rman Notes -1 Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • This is im telling Kishore Oracle
  • V$transaction notes for finding XID composition. Oracle
  • Reading parameter file and printing Linux/Unix
  • Remove duplicate rows from table Oracle
  • Space padding in korn shell Linux/Unix

Composite Index creation tip from Vivek

Posted on 06-Feb-2007 By Admin No Comments on Composite Index creation tip from Vivek

When you create a composite B-tree index, you should consider the following.

The most restrctive condition: The condition that returns the least number of rows. The column that is involved in this condition, should be the leading column of B-tree index.

So for finding the candidate of composite index columns, column order should be..

( Column involved in the most restrictive condition, …….. , column involved in the least restrictive condition).

Also, consider the data distribution while checking restrictive columns. Above analysis will work better for uniformly distributed column values.

Oracle, SQL scripts

Post navigation

Previous Post: Histogram information
Next Post: Another export with Query

Related Posts

  • UTL_FILE test program Oracle
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • Jai Shree Ram Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • Virtual Indexes in Oracle Oracle
  • Very clear article about oracle dataguard Oracle

Leave a Reply Cancel reply

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

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Oracle 11g Environment Setup Oracle
  • Implementing Listener Security Oracle
  • findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • Kill a session dynanically using execute immediate Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme