explain plan

[pnrdba]

Hi All
Following is the out put of my explain plan for a frequently running query. I couldn't understand what exactly is :
"TABLE ACCESS BY GLOBAL" ?? What exactly does this mean??



We do have partitions for that particular table but not for indexes.


Plan Table
------------------------------------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost | Pstart| Pstop |
------------------------------------------------------------------------------------------
| SELECT STATEMENT | | 7 | 357 |-3937092| | |
| FILTER | | | | | | |
| SORT GROUP BY | | 7 | 357 |-3937092| | |
| TABLE ACCESS BY GLOBAL |D_CLAIM | 1 | 20 |-275532 | 24 | 24 |
| NESTED LOOPS | | 124 | 6K|-3937092| | |
| TABLE ACCESS FULL |D_FINTX | 14K| 432K| 663 | 24 | 24 |
| INDEX RANGE SCAN |INDX_D_CLAIMFCCODE | 6K| | 4525 | | |
------------------------------------------------------------------------------------------


Can any one tell me the meaning of TABLE ACCESS BY GLOBAL pls???


Thanks in advance

[TimHall]

Hi.

I believe your routine is trimming the output and it should read something like:

TABLE ACCESS BY GLOBAL INDEX [Access Type] [Index Name]

Cheers

Tim...

[stancho]

If this is partitioned table (because you have values for pstart and pstop) that should be global index, I agree with Tim. If the index was local, it will be LOCAL.