0


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?

Hanin
  • 33
  • 5

1 Answers1

1

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

In Toad Oracle you can evaluate the global intersect query:enter image description here

Fabienne B.
  • 355
  • 1
  • 7