public IActionResult RequestDb()
{
ViewBag.IsRequestView = true;
ViewBag.Requests = DbAnalyzer.GetMostExpensiveRequest();
ViewBag.ReadableTables = DbAnalyzer.GetReadableTables();
ViewBag.WritableTables = DbAnalyzer.GetWritableTables();
return(View("AdminPanel"));
}
public IActionResult IndexDb()
{
ViewBag.IsIndexView = true;
ViewBag.RequiredIndexes = DbAnalyzer.GetRequiredIndexes();
ViewBag.UnusedIndexes = DbAnalyzer.GetUnusedIndexes();
ViewBag.MostExpensiveIndexes = DbAnalyzer.GetMostExpensiveIndexes();
ViewBag.AlterIndexText = DbAnalyzer.GetAlterIndexesSql();
return(View("AdminPanel"));
}
