If you have ever run into the dreaded "List View Threshold" error in SharePoint Online while working with sites with very large Lists, have a look at this informative blog post by Microsoft Certified SharePoint Solutions Expert Andrew Billings, where he describes a great workaround:
