What are the tradeoffs with having indexes?
Question :
What are the tradeoffs with having indexes?
Faster selects, slower updates.
Extra storage space to store indexes. Updates are slower because in
addition to updating the table you have to update the index.
Similar Questions
What is Django's middleware and how is it used?
- What are comments? Name the different types of comments used in Java.
- What are syntax errors? Give two examples.
- What are the different type of errors that may occur in a Java program?
- What is a bug? What is debugging?
- What is an accumulator?
- What is an expression?
- What is an operator? How is the classification of operators based upon?
- What is Type Conversion? Name the two type conversions in Java.
- What are separators?
- How are Decimal, Octal and Hexadecimal integer literals represented in Java?
- State two conventions you should follow while naming a class.
- What two conventions you should follow naming a class?
- State two rules you should follow for naming a class
- Why is a class called an object factory?
- What is an access specifier? Which two access specifier is used in a class declaration?
- Why is a class called a user defined data type?
- State two differences between a class and an object.
- State two differences between fundamental and user-defined data type.
- Explain the statement “Byte code is the object code for the JVMâ€