What are the dis_advantages of stored procedures, triggers,
indexes?
- 1 Answers
- 2301 Views
- I also Faced
- E-Mail Answers
Answer Posted / Ajay Kumar Chaudhary
Stored Procedures, Triggers, and Indexes have several disadvantages:
1. Stored Procedures: They can be difficult to debug and modify since they encapsulate multiple SQL statements.
2. Triggers: Can lead to performance issues due to their execution being triggered by other events and causing cascading effects.
3. Indexes: While beneficial for query performance, they consume additional storage space, take time to create and maintain, and can slow down data modification operations.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What kind of problems occurs if we do not implement proper locking strategy?
What is standby servers? Explain types of standby servers.
Equi join and non equi join is possible with sql server?
What is the difference between for xml raw and for xml auto?
Explain “row_number()” in sql server with an example?
What are different types of constraints?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How to remove duplicate rows from table except one?
Why and when do stored procedure recompile?
What is self contained sub query?
What are the properties of the transaction?
How to rebuild the master database?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Can one drop a column from a table?
