dbTalk Databases Forums  

rdb indexes

comp.databases.rdb comp.databases.rdb


Discuss rdb indexes in the comp.databases.rdb forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JR
 
Posts: n/a

Default rdb indexes - 10-28-2004 , 10:20 PM






Had anyone ever had deadlock issues when using a date-timestamp as a single
segmented index?
JR




Reply With Quote
  #2  
Old   
Norman Lastovica
 
Posts: n/a

Default Re: rdb indexes - 11-02-2004 , 05:03 PM






often using an ascending value in a sorted
index causes significant contention for the
"lower right corner" of the index. while
this, in itself, can not cause deadlocks,
the contention can limit performance. please
contact oracle rdb support directly for
additional assistance in resolving this sort
of performance issue.

JR wrote:
Quote:
Had anyone ever had deadlock issues when using a date-timestamp as a single
segmented index?
JR
--
- - - - -
opinions expressed here are mine and mine alone
and certainly are not intended in any way to
express or represent any opinions or commitment
of oracle corporation.

norman lastovica / oracle rdb engineering


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.