Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DELETED() tag does not help rushmore optimisation

Status
Not open for further replies.
ramani

ramani

Programmer
Mar 15, 2001
4,336
AE
==================================================
An article by Charlie Schreiner on his exploration of Rushmore optimization. The article shows that adding a tag for deleted records is not a good practice, but that’s not really the important issue. The important thing, and harder to understand than a simple rule, is the tradeoff involved in creating and utilizing index tags; any index tag, not just a tag on DELETED().

ramani :)

I believe in the above article as I have done similar tests earlier, but was reluctatnt to say it so, since the gurus say the other way and as well SYS(3054,1) showed the other way. Now I can surely say that DELETED() tag does not help to achieve speed.

ramani :)
 
Status
Not open for further replies.

Similar threads

Vince Wen
  • Question
.dbf files mysteriously gone missing (or being deleted)
2 3
Replies
55
Views
2K
Vince Wen
Vince Wen
EinTerraner
  • Locked
  • Question
index does not match the table
Replies
15
Views
2K
EinTerraner
EinTerraner
SitesMasstec
  • Locked
  • Question
Set a TAG for a field programmaticaly 3
2
Replies
29
Views
2K
SitesMasstec
SitesMasstec
SitesMasstec
  • Locked
  • Question
Create a table with Tag indexes 1
Replies
13
Views
1K
TamarGranor
TamarGranor
SitesMasstec
  • Locked
  • Question
INDEX versus TAG 5
2
Replies
39
Views
2K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top