Pandas ENH: Adding hint to to_sql

Feature Type

• [ ] Adding new functionality to pandas

• [x] Changing existing functionality in pandas

• [ ] Removing existing functionality in pandas

Problem Description

It would be great if we able use hints with to_sql. Especially /APPEND PARALLEL/ hints greatly improves insert time in Oracle.

Feature Description

with db().connect() as connection: df.to_sql('TEST_TABLE', connection, hints={'ORACLE':['APPEND', 'PARALLEL']}

Alternative Solutions

with db().connect() as connection: df.to_sql('TEST_TABLE', connection, hints={'ORACLE':['APPEND', 'PARALLEL']}

Additional Context

No response