Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Steve,
>I found out that the SQL SELECT is much faster than the SET FILTER in my testing today.
Watch out with this conclusion. It heavely depends on the selectivity of the query. If SQL is used to filter out a small set out of a large table, SQL is the clear winner here. However if you want to filter out only a small percentage of the (large) table SQL isn't worth the cost: use a SET FILTER instead.
Walter,
Previous
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