Wednesday 9 October 2013

06. Display the details of all the credit cards that are of type SuperiorCard. The CreditCard table contains a large amount of data. Therefore, the query takes a long time to retrieve the details of the credit card. You need to optimize the execution of the query so that the result set does not take too much time to be retrieved.

select * from sales.CreditCard
Where Contains(CardType,'SuperiorCard')

No comments:

Post a Comment