General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
From the Hacker's Guide on filtered indexes:
However, any index that's filtered in this way is ignored by Rushmore when it attempts to optimize commands, so use these cautiously. (Don't be misled by the VFP 6 Help, which seems to imply that filtered tags are used by Rushmore. In fact, what it's really saying is that Rushmore will optimize the INDEX command itself if appropriate tags exist.)
>I have to argue with you on this because we tried using views just to extract a few hundred records from over 1 million records and we compared it to filtered indexes. And the difference is significant. IMO, rushmore also applies to filtered indexes because the logic behind it is the same with FOR, SET FILTER etc. which are RUSHMORE enabled.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only