Discussion
Indexes may be created or dropped at any time.
Answer: A
Correct answer: True
Indexes are physical structures, separate from the logical design, so CREATE INDEX and DROP INDEX can be issued at any time without altering the tables or the queries that use them.
That independence is the point: an index changes how fast a query runs, never what it returns, so one can be added when a query proves slow and dropped when it is no longer earning its keep. The practical caveat is timing rather than legality - building an index on a large table takes time and may lock it, so it is usually done off-peak.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development