Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Disbaling DBA_SCHEDULER_JOBS Oracle
  • replace alphabets using sed Linux/Unix
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • How to Modify the statistics collection by MMON for AWR repository Oracle
  • switchover for primary database Oracle
  • Jai Shree Ram PHP/MYSQL/Wordpress
  • Running select from V$ views from remote server Linux/Unix
  • Default User Profile Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • My Minimum Tuning Programs Oracle
  • Ports used by Oracle Software Oracle
  • find_idle_cpu.sql Oracle
  • Specify the Rollback segment to use in Transaction Oracle

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

  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • Oracle Identifiers Oracle
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • Wait.sql 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 (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • kill all processes from specific user in solaris. Linux/Unix
  • database trigger failing Oracle
  • note id 373303.1 Linux/Unix
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • Wait.sql Oracle
  • Jai Shree Ram Linux/Unix
  • Kernel Parameter setting explaination for Processes Parameter Linux/Unix
  • plan10g.sql good1 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme