Suppose that a B tree index on branch city is available on
Suppose that a B+-tree index on branch-city is available on relation branch, and that no other index is available. What would be the best way to handle the following selections that involve negation?
a. σ ¬ (branch-city<“Brooklyn”)(branch)
b. σ ¬ (branch-city=“Brooklyn”)(branch)
c. σ ¬ (branch-city<“Brooklyn” ∨ assets<5000)(branch)
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help