Interested to Buy Any Domain ? << Click Here >> for more details...
WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
- 4 Answers
- 8362 Views
- CTS, iNautix, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priya sahoo
create index on the table so that query retrival is faster
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / deepak soni
if you talk about sql you should create clusterd index
but in oracle you have to create indexes to improve the
performance of query or you can say retrive the data in
faster rate.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / muzaffar ali umrani
first check is there any index created in on that table, if yes then arrange your query according to index and check its execution plan and if there is no index on query then create the index.
| Is This Answer Correct ? | 7 Yes | 0 No |
What is the main purpose of normalization?
What are the types of rdbms?
What are the ACID Properties in a Database and Why are They Important?
What is a database in healthcare?
Explain a database server?
when A set of Dictionary tables are created ?
From which command ENQUEUE_RESOURCES parameter information is derived from ?
What is database management system(dbms) and why it is used?
What is dbms with example?
Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.
Why dbms is used?
What is the importance of database in an organization?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
