The view
vw_ftrucf_index
is build on serveral tables including 
index_curr_analytic
which has 219 partitions

when the index 'pk_index_curr_analytics' is built on the index_curr_analytics table
running explain select * from vw_ftrucf_index;

takes an extremly long time (over 5 hours on my Mac) and returns a bad explain plan

running explain without the above index or on a table with just one partition the explain plan retruns in around one second

the files
explain.out contains a good explain plan (on a non-partitioned version of the tables)
explain_error.out is an example of the incorrect plan.

the following file list are the non-partitioned tables plus the view deffinition
tbl_attribute_types.sql
tbl_attributes.sql
tbl_currencies.sql
tbl_data_types.sql
tbl_dates.sql
tbl_index_master.sql
tbl_sources.sql
vw_ftrucf_index.sql

the direcotries:
  part
    are the create script to crated the partitioned tables used in the veiw
  nopart 
    are the same tables created as non-partitioned tables
  partition 
    creates each partion for index_curr_analytic and index_main tables
  index
    the indexs on the non-partitioned tables in the view
  index_part
    the indexes on the partitioned_tables in the view

the scripts:

install_part.sql:
  creates a schema bmk
  creates all tables including partitioned tables and the view definition

install_nopart.sql:
  creates a schemabmk
  creates the tables and the view definition.  these are non-partitioned tables

install_partitions.sql:
  creates all the partitons

install_index_nopart.sql:
  creates the indexs on the non-partitioned tables

install_index_part.sql:
  creates the indexes on the partitioned tables
