could you please state the work-around from each above bottlenecks? as these (files of various size, tables with high number of columns, Joins etc.) are very common use cases in data processing.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.