Question
Please answer following questions with sql languange. 1)Drop the (1) PlaceOfBusiness=> Customerforeign key and the (2) primary key constraint of Customer. Run and examine the
Please answer following questions with sql languange.
1)Drop the (1) PlaceOfBusiness=> Customerforeign key and the (2) primary key constraint of Customer. Run and examine the execution plans of the following queries on the Customertable:
a)Query the full table
b)Get one record based on primary key
c)Querying records, whose primary key is not a specified constant ()
d)Querying records, whose primary key is greater than aspecified constant e)Querying records, whose primary key is greater than a specified constant, ordering by ID, in descending order.
2)Recreate the primary keyon the Customer table (containingthe ID field)and execute the queries again. Explain what changes in the execution plans.
3)Execute the queries from aboveon table Product, but use the Pricecolumn instead of the primary key, both forthe condition and for sorting.
4)Add anew nonclusteredindex on Price. How do the execution plans change? Explain the changes.
Payment Method & ID Customer VID Method Deadline Order ID Date Deadline PlaceOfBusinessID StatusID Payment MethodID PlaceOfBusiness ID Zip Code City Street Name Bank Account Tel Login Password Email MainPlaceOfBusiness Fax CustomerID Status 2 ID Name Orderltem 2 ID Amount Invoice Y ID Price OrderID ProductID Statusid Category Invoicelssuer ID Name Zip Code City Street Taxidentifier BankAccount Name ParentCategory CustomerName Customer Zip Code CustomerCity Customer Street PrintedCopies Cancelled Payment Method Creation Date DeliveryDate Payment Deadline Invoicelssuerid Orderid Product VAT Name Invoiceltem ID Percentage Name Price InStock VATID CategoryID Description Amount Price VATPercentage Invoicell OrderitemID Image Payment Method & ID Customer VID Method Deadline Order ID Date Deadline PlaceOfBusinessID StatusID Payment MethodID PlaceOfBusiness ID Zip Code City Street Name Bank Account Tel Login Password Email MainPlaceOfBusiness Fax CustomerID Status 2 ID Name Orderltem 2 ID Amount Invoice Y ID Price OrderID ProductID Statusid Category Invoicelssuer ID Name Zip Code City Street Taxidentifier BankAccount Name ParentCategory CustomerName Customer Zip Code CustomerCity Customer Street PrintedCopies Cancelled Payment Method Creation Date DeliveryDate Payment Deadline Invoicelssuerid Orderid Product VAT Name Invoiceltem ID Percentage Name Price InStock VATID CategoryID Description Amount Price VATPercentage Invoicell OrderitemID ImageStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started