Which is better to grow plants sand or soil?

It depends on the plant, but most houseplants (with the exception of cacti) will grow better in a potting mix (soil) made for container plants.