The Gateway to Computer Science Excellence
0 votes

Q Consider a relation R(a, b, c) ordered on a non-key attribute b, and an index is maintained on attribute c. To evaluate the following expression, which is a better order of operation? σ(b=‘abc’∧c=12)(R)

A. First filter tuples using index on c and then search for b

B. First search tuples for the given value of b and then use index on c

C. The order of operation does not matter

D. Insufficient data to answer


in Databases by (195 points) | 57 views
Yes plz explain

Please log in or register to answer this question.

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,258 answers
104,735 users