-
If there is a query that is "SELECT * FROM DEPT WHERE DEPTNO=10 AND DEPTNM = 'marketing'", the best index(es) to put on the table would be.. (Choose one)
a. an index on deptno
b. an index on deptnm
c. an index on both deptno and deptnm
d. a concatenated index on deptno and deptnm
I CHOOSE D - What do yous guys think?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|