General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Yes in trial runs, with the files table only having 50,000 or so records, it seems to make no appreciable difference on speed. Just gotta get used to using it (like anything).
thanks
>
>Agree that EXISTS is better here because it makes really clear what you're looking for. I suspect it'll get optimized anyway into one query that collects the whole set and then is filtered for each record. So I'd be surprised if there's a significant speed difference.
>
>Tamar
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