![]() ![]() ![]() Network load is considerably less.Īll frequently used, read-only tables, try to use SAP buffering. Internal table handling takesĪ select list or a view instead of Select *, if you are only interested in ![]() You process your data only once, use a Select-Endselect-loop instead of collectingĭata in an internal table with Select Into Table. You want to find the maximum, minimum, sum and average value or the count ofĪ database column, use a select list with aggregate functions instead of computing Read data from several logically connected tables use a join instead of nested Is always faster to use the Into Table version of a Select statement than to Requires one communication with the database system, whereas Select-Endselect Use the Select Single statement instead of a Select-Endselect-loop. There exists at least one row of a database table or view with a certain condition, Note that complex WhereĬlauses are poison for the statement optimizer in any database system. Logical Ands in the Select statement's Where clause. Index if you specify (a generic part of) the index fields concatenated with The database system can then use an index (if possible)Īnd the network load is considerably less.Īll frequently used Select statements, try to use an index. Specify your conditions in the Where-clause instead of checking them yourself Here is a non-JavaScript version of the image slideshow: Since your web browser does not support JavaScript, ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |