Re: NT vs Unix

An odd thing about your example - it doesn't appear to be a partition = view
a) The UNION ALL line should report the option (PARTITION) b) With your select statement the eliminated partitions should be = preceded by a line reading FILTER and
c) Eliminated partitions should show a row count of ZERO - not a = rowcount of 1.

Judging from the output, the view appears to be an ordinary UNION ALL = view where each table has an
index on (billcycle, customer_id).

Suggest you check with Aunt Augusta

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

    Peter Lomax wrote in message <36A5D3EB.7DFB3DDB_at_turk.net>...     Plug best DBA site is without a doubt www.oriolecorp.com ask Aunt = Augusta she knows.

    e.g.

    =
==========================
==========================
==========================
======= 

    Selection on the partitioned view CUSTOMER_X with index en version = 7.3.4.3

    =
==========================
==========================
==========================
======= 

    select count(*) from CUSTOMER_X where billcycle = '04' and = customer_id < 70001

    call     count       cpu    elapsed       disk      query    current =
       rows 

• ------ -------- ---------- ---------- ---------- ---------- =

  ---

  Parse 1 0.90 0.92 34 1692 0 = 0 Execute 1 0.00 0.00 0 0 0 = 0 Fetch 1 0.14 0.22 57 57 0 = 1
• ------ -------- ---------- ---------- ---------- ---------- =

  ---

  total 3 1.04 1.14 91 1749 0 = 1

    Rows Execution Plan

• --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (AGGREGATE) 16111 VIEW OF 'CUSTOMER_X' 16111 UNION-ALL 1 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_01' =
  (NON-UNIQUE)
  1 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_02' =
  (NON-UNIQUE)
  1 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_03' =
  (NON-UNIQUE)
  16112 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_04' =
  (NON-UNIQUE)
  1 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_05' =
  (NON-UNIQUE)
  1 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_06' =
  (NON-UNIQUE)
  1 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_07' =
  (NON-UNIQUE)
  1 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_08' =
  (NON-UNIQUE)
  1 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CUST_ALL_I_09' =
  (NON-UNIQUE)