DATA DICTIONARY part2.

TECHNICAL SETTINGS :-

§To individually optimize the storage requirements and accessing behavior of database tables.

 Provides various features like – buffering, logging
https://www.youtube.com/channel/UCq55W5Hi-Cs8U4O590q6e0Q

INDEX BUFFERING:-

nTo increase the performance when records from the table are read.

nThree types of buffering:

¨Full Buffering

¨Generic  Buffering

¨Single Record Buffering

Operations on Tables:-

SYNTAX:-

Syntax:

            UPDATE <target> SET <set1> <set 2> 

[WHERE <cond>]. 

Syntax:

       DELETE  FROM <TABLE NAME> WHERE <COND>