Home » RDBMS Server » Performance Tuning » Confusion about Partitioning (11g,HP-UNIX B11.23)
Confusion about Partitioning [message #484744] Thu, 02 December 2010 08:54 Go to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Hi,
I have table named W_GL_OTHER_F which has a column X_CURRENCY_CODE which has 1232699 rows but has only 6 distinct values. The column has a bitmap index on it also. Will it be good to partition this table taking the X_CURRENCY_CODE column as Hash partition key ?? Please suggest the pros and cons.



Report message to a moderator

Re: Confusion about Partitioning [message #484745 is a reply to message #484744] Thu, 02 December 2010 08:58 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post EXPLAIN PLAN for SQL using this column against current table & after partitioned.

Report message to a moderator

Previous Topic: Why oracle doesn't use the index?
Next Topic: Trailing issue during processing huge data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 12:40:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.