Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
> Creating a multi column Index, What are the rule to define the position of a column in an index?
ich
post Jan 24 2012, 12:32 PM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 24-January 12
Member No.: 46,648



Hi

I have in my database (OLTP-System) a table with about 6000000 records and a zise of about 2GB.

can some body give me some hints about the way to create multi_column indexes on the table?
What are the rule to define the best-position of a column in an index?
index_1(col_1,Col_2,col_3) and not [ (col_1,Col_3,col_2) or (col_2,Col_3,col_1) or (col_2,Col_1,col_3) or (col_3,Col_2,col_1) or (col_3,Col_1,col_2) ] ?


Kind Regrads
Ich

Go to the top of the page
 
+Quote Post
 
Start new topic
Replies
burleson
post Jan 24 2012, 03:16 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,508
Joined: 26-January 04
Member No.: 13



Hi Ich,

>> a table with about 6000000 record

Make sure to partition the table AND all indexes:

http://rampant-books.com/art_hernandez_par...g_in_oracle.htm

http://dba-oracle.com/googlesearchsite_pro...ealth_check.htm


******************************************
>> What are the rule to define the best-position of a column in an index?

It's driven by the SQL workload against the table . . .

Please read:

http://www.dba-oracle.com/t_composite_inde...mn_ordering.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2014 - 03:22 PM