>A friend of mine told me that local views perform better (faster) than 'set filter to' instructions. I have a table with 12.000 records with a cdx index using 3 separate keys and it seems that filters are faster than views?. Does anyone have comments... Thanks in advanced for any help
Consider some benchmarking, because it depends on what you're doing.
It's very important to have the filtered expression indexed.
Also, views are faster to manipulate because you'll have a smaller set of records, while Filters actually skip records through the table.
Alexandre Nobre
Alpha Bytes Computer Corp.
Did you know that there are innocent people dying in East Timor?
It helps if you do...
I suppose you don't need glasses if you're able to read this line