| Relationsip between Parallel Degree & Clustering Factor [message #347109] |
Wed, 10 September 2008 13:58  |
feroze
Messages: 144
Registered: September 2005
Location: chicago
|
Senior Member |
|
|
Hi,
We usually create index on large tables with Parallel Degree 4 or 8 and after creating set it back to 1, ( Global and Local ).
Some body pointed that creating with Parallel increases the clustering_factor of index, How far is it True, and is there a relation between these 2.
Thanks
|
|
|
|
|
|
|
|
| Re: Relationsip between Parallel Degree & Clustering Factor [message #347124 is a reply to message #347109] |
Wed, 10 September 2008 16:26  |
harrysmall3
Messages: 109
Registered: April 2008
Location: Massachusetts
|
Senior Member |
|
|
I'd also ask that person ("the someone") how CAN that be true?
I dont think anything you can do to an index is going to change the physical order of the table data and the number of contiguous or non-contiguous blocks in which they are contained.
So, I can not see any relationship between the two.
Build the index with different settings and compare
Regards,
Harry
|
|
|
|
| Re: Relationsip between Parallel Degree & Clustering Factor [message #349406 is a reply to message #347109] |
Sun, 21 September 2008 09:45 |
VivekSharma
Messages: 2
Registered: September 2008
Location: Mumbai, India
|
Junior Member |
|
|
Hi Feroze,
Yes, the statement that Rebuilding or Creating an Index in parallel can impact Clustering Factor is totally false but it is also quite possible that you might have wrongly interpreted the words of that SOMEBODY 
With that said, if you insert rows into a table in parallel and each parallel jobs getting one of the value to be inserted from Sequences or one of the value is a DATE field, then, yes, it can impact your clustering factor.
Regards
Vivek
[Updated on: Sun, 21 September 2008 11:39] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
