title: Oracle Partitioned table is taking long time to fetch
body: <p>I have a partioned table based on date in oracle db, where each partition has crores of records. The front end application is build to search the data based on a date range (meanining it scans through multiple partitions). What is the best logic to get the data in quickest time?</p>