RE: can we drop the index on composite partitioned table
- From: "Ian Cary (C)" <Ian.Cary@xxxxxxxxxxxxxxxxxxxx>
- To: <sarath_kumar0@xxxxxxxxx>, "oracleMail List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 May 2005 08:50:08 +0100
The index isn't used to drive partition elimination, so unless you are runn=
ing queries that only target a small range of rows within a partition using=
the partitioning key as a where predicate is it better NOT to have an inde=
x based on the partitioning key column.
Cheers,
Ian
This email is only intended for the person to whom it is addressed and may =
contain confidential information. If you have received this email in error,=
please notify the sender and delete this email which must not be copied, d=
istributed or disclosed to any other person.
Unless stated otherwise, the contents of this email are personal to the wri=
ter and do not represent the official view of Ordnance Survey. Nor can any =
contract be formed on Ordnance Survey's behalf via email. We reserve the ri=
ght to monitor emails and attachments without prior notice.
Thank you for your cooperation.
Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk
--
//www.freelists.org/webpage/oracle-l
Other related posts:
