Show me the steps to solve Collect statistics on your fact tables. Provide screenshots and output from your DBCC SHOW

$\_$

STATISTICS command. Next discuss why and how you would use these statistics of a health record table CREATE TABLE DrugRecords

$($

DrugRecordID INT PRIMARY KEY,

PatientID INT,

DrugName VARCHAR

$($

$2$

$5$

$5$

$)$

$,$

PrescriptionDate DATE,

Dosage VARCHAR

$($

$2$

$5$

$5$

$)$

$,$

PrescribingDoctorID INT