Answer / Rishabh Kesarwani

Generally speaking, stored procedures tend to be faster than views because views are essentially SQL queries that are saved as database objects. They are evaluated each time they are accessed, which can lead to performance issues if the query is complex or the data being accessed is large. Stored procedures, however, are precompiled and executed more efficiently.

how does a local variable is defined using t-sql? : Transact sql

1 Answers  

---

What is clause in sql?

1 Answers  

---

What are the advantages of pl sql over sql?

1 Answers  

---

What has stored procedures in sql?

1 Answers  

---

How do I partition in sql?

1 Answers  

---

What is a delimiter in sas?

1 Answers  

---

Which are the different case manipulation functions in sql?

1 Answers  

---

What do you think about pl/sql?

1 Answers  

---

what is oltp (online transaction processing)? : Sql dba

1 Answers  

---

What is sql constant?

1 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

What are records give examples?

1 Answers  

---