DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: INDEXES

  1. 10-20-2002, 04:34 PM #1
    Lani2000
    Lani2000 is offline Junior Member
    Join Date
    Nov 2001
    Location
    Atlanta GA
    Posts
    45
    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?
    Reply With Quote Reply With Quote
  2. 10-20-2002, 04:52 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    moving to certification
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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