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
Previous Topic: tkprof
Next Topic: db peak time urgent
Goto Forum:
  


Current Time: Thu Mar 28 20:59:44 CDT 2024