如何提高以下查询的效率以防止超时

CREATE INDEX idx_column_name ON table_name(column_name);

-- 原始嵌套查询
SELECT * FROM table1 WHERE id IN (SELECT id FROM table2 WHERE condition);

-- 优化后的连接查询
SELECT table1.* FROM table1 JOIN table2 ON table1.id = table2.id WHERE table2.condition;

SELECT * FROM table_name ORDER BY column_name LIMIT 10 OFFSET 20;

import redis

r = redis.Redis(host='localhost', port=6379, db=0)
result = r.get('key')
if result is None:
    result = perform_expensive_query()
    r.set('key', result)

from concurrent.futures import ThreadPoolExecutor

def query_task(query):
    # 执行查询
    pass

queries = ['query1', 'query2', 'query3']
with ThreadPoolExecutor(max_workers=3) as executor:
    results = list(executor.map(query_task, queries))