General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Select ;
Union Select Where NOT Exists Select
How does the SQL engine perform this task? Is the selection gathered twice, or does the result set get reused?
The reason i ask is because it would make more sense to issue several Selects and reuse the intermediate results than to phrase one SQL statement that causes several redundant selects. I'm sure one statement would be better on a back-end DB server (SQL/Oracle) but on a native VFP table, which method is optimal?
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