DescriptionThis!group!assignment!provides!an!opportunity!to!gain!some!practical!experience!with!indexing.!!The!experiment!of!the!week!assignments!are!intended!to!be!more!open,!with!your!group!picking!the!specific!topics!to!investigate.!!Basically,!this!gives!you!a!chance!to!be!a!bit!more!creative!and!follow!directions!of!specific!interest!to!you!(and!more!relevant!to!your!career).!!Besides!creativity,!you!should!try!to!pick!experiments!that!are!interesting!and!carry!them!out!with!good!technical!skill.!!That!does!not!mean!the!results!have!to!be!in!line!with!your!intuition,!counterSintuitive!yet!interesting!results!are!great.!!Besides!the!topic!of!the!week,!such!as!query!processing, you!are!free!to!bring!in!any!past!topics!to!complement!your!experiments.!!For!instance,!you!might!develop!some!new!queries!that!fit!better!with!the!current!experiments.The!deliverable!is!an!experiment!of!the!week!writeSup!that!includes!an!explanation!of!each!experiment,!along!with!screenshots,!figures,!and/or!tables!that!highlight!key!steps!or!results.!!Along!with!some!ideas!below,!there!are!hall!of!fame!examples!that!show!fragments!of!past!student!projects.!!These!fragments!and!hints!are!selected!because!of!interesting!features,!but!are!not!guaranteed!to!be!completely!correct.!!So,!use!them!for!inspiration!and!develop!your!own!informed!results!(i.e.,!trust!but!verify).!!Together!these!hints!and!ideas!should!help!you!complete!your!assignments!and!learn!along!the!way.Project+IdeasIdeaThe+Role+of+StatisticsMost!commercial!databases!rely!on!costSbased!optimization!(CBO)!approaches.!!Therefore,!the!available!statistics!play!a!big!role!in!the!choices!made!by!the!optimizer.!!You!can!modify!the!types!of!statistics!that!are!collected.!!For!instance,!you!can!ask!for!additional!column!level!statistics!to!be!collected!(especially!when!the!distribution!of!domain!values!is!skewed).!!Look!at!how!changes!in!statistics!are!reflected!in!the!execution!plans!produced.!!In!fact,!even!simple!changes!in!table!size!can!affect!the!execution!plans!(the!number!of!rows!is!a!basic!statistic!used!by!the!optimizer.