Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015
    Posts
    1

    Unanswered: explain plan for partition table

    hello,
    i have a question about explain plan for partition table.
    i have created two tables, one of them is partitioned and the other one is not.
    when i execute a query for analyzing the two tables and ask for the explain plans i am not sure what does ROW and BYTE mean?
    below i wrote two examples from the same query where in the first example i have used non-partitioned table and in the second example a partitioned one:

    1. explain plan for the non-partitioned table

    | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
    -------------------------------------------------------------------------------
    | 0 | SELECT STATEMENT | | 296K| 33M| 14126 (1)| 00:02:50 |
    |* 1 | TABLE ACCESS FULL | PAGESA_PA | 296K| 33M| 14126 (1)| 00:02:50 |


    2. explain plan for the partitioned table

    | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time| Pstart| Pstop |
    -------------------------------------------------------------------------------------------------
    | 0 | SELECT STATEMENT | | 295K| 33M| 7118 (1)| 00:01:26 | | |
    | 1 | PARTITION RANGE SINGLE | | 295K| 33M| 7118 (1)| 00:01:26 | 10 | 10 |
    |* 2 | TABLE ACCESS FULL | PAGESA | 295K| 33M| 7118 (1)| 00:01:26 | 10 | 10 |

    from these two examples we can see that columns ROW and BYTES have the same values. is there any mistake in these two examples because columns ROW and BYTES have the same values, or when we explain partitioned table these two columns are not important? what is the importance of these two columns in explain plan?

    thank you in advance,
    with respect shkupi,

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •