MySQL Forums :: Partitioning :: wrong output generate while using partitions


Advanced Search

Re: wrong output generate while using partitions
Posted by: Shivam Patel ()
Date: December 16, 2014 04:00AM

Actual table and data set is different. I got the same output which you got, if I used this given sample table and data set.

I gave you sample table structure (with less no. of columns but actual datatype) and sample data set.

In actual table, there is 15 columns and 30 lacs data in it.

I gave you ACTUAL EXECUTION PLAN in my first post which were generated from actual data set and table, from which you can get idea that even execution plan were not generated same on with partitioned and without partitioned table.

Options: ReplyQuote


Subject Views Written By Posted
wrong output generate while using partitions 1884 Shivam Patel 12/13/2014 07:56AM
Re: wrong output generate while using partitions 905 Rick James 12/14/2014 10:33PM
Re: wrong output generate while using partitions 876 Shivam Patel 12/16/2014 01:24AM
Re: wrong output generate while using partitions 931 Jonathan Stephens 12/16/2014 02:32AM
Re: wrong output generate while using partitions 946 Shivam Patel 12/16/2014 04:00AM
Re: wrong output generate while using partitions 863 Rick James 12/16/2014 04:28PM
Re: wrong output generate while using partitions 976 Shivam Patel 12/17/2014 07:20AM
Re: wrong output generate while using partitions 987 Rick James 12/17/2014 11:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.