TRANSPARANT TABLE:

ü      From those list if we look into TRANSPARANT TABLE

TRANSPARANT TABLE:

      Having application server and having db server

      We can find ABAP dictionary in application server

      Database table(eno, ename) is nothing but transparent table

• If it is Transparent table, in that case structure in ABAP dictionary is same as structure in database

ü                                      Having SAP R/3 database and having 5000 transparent tables

ü                                      Working under web based

ü                                      Layer is nothing but clustard layer

Using CLUSTER & POOLED tables performance can be improved in SAP R/3.

§                                         CLUSTER follows binary search

§                                         POOLED follows Linearly search.

§                     Apart from a data class we can work with size category

Size category: it can provide size of the data which respective table maintains

Þ                                      If  I say zero(0) under respective table upto 61000 records

Þ                                     apart from zero(0) even we have the option 1 to 9(size category)