Hi,

Below is the explain for select *

SQL> explain plan set statement_id='OCT30' for
2 SELECT * FROM "JCDS" WHERE "MANDT" = 100 AND "OBJNR" BETWEEN 'VB*' AND 'VB99999999999999999999' AND "INACT" = ' ';

Explained.

Plan Table
--------------------------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost | Pstart| Pstop |
--------------------------------------------------------------------------------
| SELECT STATEMENT | | 2K| 136K| 121 | | |
| TABLE ACCESS BY INDEX ROW|JCDS | 2K| 136K| 120 | | |
| INDEX SKIP SCAN |JCDS~0 | 316 | | 82 | | |
--------------------------------------------------------------------------------

6 rows selected.

Regards
Jay