How does Pandas optimize memory usage in join vs merge operations?

join is index-based and often more memory-efficient than merge.

join operates primarily on indexes, reducing the need for key construction. merge requires explicit key handling and may allocate additional memory for hash tables. For large datasets, index-based joins can be more efficient if data is pre-indexed.