1.

What Structure Can You Implement For The Database To Speed Up Table Reads?

Answer»

Follow the rules of DB tuning we have to:

  1. properly use INDEXES ( different types of indexes)
  2. properly LOCATE different DB objects across different tablespaces, files and so on.
  3. CREATE a SPECIAL space (tablespace) to locate some of the data with special datatype ( for EXAMPLE CLOB, LOB and …)

Follow the rules of DB tuning we have to:


Discussion

No Comment Found

Related InterviewSolutions