Query evaluation with "INTERSECT" function

Question

I've a query:

QUERY1{statements...} 
INTERSECT
QUERY2{statements...}

I need to evaluate these 2 queries according to giving database data,
my question is: do I have to evaluate each query separately and then combine the 2 results together?
i.g: cost(Query1) + cost(Query2) = Total query's cost ? .. or there is another way to solve this?

MySQL doesn't support intersect, so your query is not going to run. — Gordon Linoff
– Gordon Linoff, Commented Aug 31, 2015 at 13:34

Fabienne B. · Accepted Answer · 2015-08-31 13:48:11Z

1

Yes, you have to add the 2 queries' cost.

In Toad Oracle you can evaluate the global intersect query:

answered Aug 31, 2015 at 13:48

Fabienne B.

3631 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query evaluation with "INTERSECT" function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related