General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Rushmore failing for most tags on one table
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
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