| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> sql*loader performance
Hi all
Does anyone know if specifying a PARTITION clause in a sql*loader control file improves performance when loading into a partitioned table? We will be doing DIRECT loads of several million rows.
Regards,
Darryl Tappenden
Oracle Database Administrator
email: darryl.tappenden_at_lloydstsb.co.uk
Tel (int): 465 3509 Tel (ext): 0207 232 3509This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender.
-----------------------------------------------------------------------------------------------------------------------
evolvebank.com is a division of Lloyds TSB Bank plc. Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS. Registered in England, number 2065. Telephone No: 020 7626 1500 Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone No: 0131 225 4555
Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the Personal Investment Authority and represent only the Scottish Widows and Lloyds TSB Marketing Group for life assurance, pensions and investment business.
Members of the UK Banking Ombudsman Scheme and signatories to the UK Banking Code.
 |
 |