Home » RDBMS Server » Performance Tuning » Reverse Key Indexes
Reverse Key Indexes [message #65177] Mon, 31 May 2004 18:54
Avi
Messages: 23
Registered: January 2002
Junior Member
Hi Guys,  

  Can anybosy point me to the pros and cons of reverse key indexes. The one I know is that it prevents the growth of index tree on to just one side....but on the other hand....Reverse key indexes are not used for Range Scan any additional thoughts are more than welcome.

Regards

Avi Soni

Report message to a moderator

Previous Topic: tkprof
Next Topic: db peak time urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 23:56:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.