Skip to content

ENH: Adding hint to to_sql #61370

Open
Open
@AliKayhanAtay

Description

@AliKayhanAtay

Feature Type

  • Adding new functionality to pandas

  • 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

Metadata

Metadata

Assignees

No one assigned

    Labels

    EnhancementNeeds TriageIssue that has not been reviewed by a pandas team member

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions