例：SELECT * FROM table_name LIMIT 10 OFFSET 0;
例：SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY column_name) AS row_num FROM table_name ) AS temp WHERE row_num BETWEEN 1 AND 10;
例：SELECT * FROM ( SELECT * FROM table_name ) AS temp LIMIT 10 OFFSET 0;
例：CREATE INDEX index_name ON table_name (column_name);
以上是一些提升SQL分頁查詢性能的方法，可以根據實際情況選擇合適的方法來優化查詢性能。
