Why are indexes and views important to an organization?
- 1 Answers
- 1042 Views
- I also Faced
- E-Mail Answers
Answer Posted / Dipal Singh Rana
Indexes help improve the performance of database queries by reducing the amount of data that needs to be scanned. They can significantly speed up read operations, especially on large tables. Views, on the other hand, provide a way to present complex queries as simple objects, making it easier for users to work with the data. This can improve productivity and reduce errors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is bcp? When does it used? : Sql dba
How do I remove duplicates in two columns?
what is schema? : Sql dba
Can we rollback truncate?
what is collation? : Sql dba
Do we need to rebuild index after truncate?
What is the current version of sql?
what are all the common sql function? : Sql dba
what are the advantages of sql ? : Sql dba
What is the best sql course?
Is primary key clustered index?
how to start mysql server? : Sql dba
what is dbms? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
define sql insert statement ? : Sql dba
