It depends on the purpose of the hoop. If you are just going to use it as a basketball hoop, then water is the best choice. If you want to use the hoop for other purposes, such as playing water polo or water balloon toss, then sand is better.