I remember a long time ago I learned that CPDBF() and CPCURRENT() must have the same value, if not rushmore won't work.
>Got a really weird one here. I have a table from a client app where Rushmore is not kicking in for most of the tags. The table has over 100 fields. (I didn't design this; I inherited it.) There are 19 tags; 10 of them are filtered. Obviously, I'm not expecting those to help with optimization.
>
>When I test queries with SYS(3054), only one of the other 9 tags contributes to optimization. That tag corresponds to the table's effective primary key (it's a regular tag, but it's the PK field). When I run a query that filters on any of the others, I get optimization of "None".
>
>I've rebuilt all the tags from scratch. I also tried adding a tag on a previously unindexed field and using that in a WHERE clause. No optimization.
>
>I've tried this with two different copies of the table in different folders with the same results.
>
>I made a copy of the table and started indexing one tag at a time and optimization worked as I expected. I thought maybe the problem was the presence of the filtered tags, so I added one of those, and optimization still worked as I expected for the other tags.
>
>Anybody seen anything like this before?
>
>Tamar