import pandas as pd
import cr_Oracle as cx
conn = cx.connect("aa", "123456", "ip:1521/test")
account = pd.read_sql(sql="select STOCK_ACCOUNT, UAP_ACCOUNT from account", con=conn)
print(account.head())
这条查询语句需要130秒,太慢了,怎么优化加快read_sql的查询速度?
import pandas as pd
import cr_Oracle as cx
conn = cx.connect("aa", "123456", "ip:1521/test")
account = pd.read_sql(sql="select STOCK_ACCOUNT, UAP_ACCOUNT from account", con=conn)
print(account.head())
这条查询语句需要130秒,太慢了,怎么优化加快read_sql的查询速度?