Illustrate how SQL can be used to create an index called CUSTOMER_INDEX, on the table with name
Question:
Illustrate how SQL can be used to create an index called CUSTOMER_INDEX, on the table with name CUSTOMERS based on the CUSTOMER_AGE (descending) and CUSTOMER_ZIPCODE (ascending) attribute types. Give a minimum of three reasons why choosing an appropriate index can be beneficial.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Principles Of Database Management The Practical Guide To Storing Managing And Analyzing Big And Small Data
ISBN: 9781107186125
1st Edition
Authors: Wilfried Lemahieu, Seppe Vanden Broucke, Bart Baesens
Question Posted: