Interested to Buy Any Domain ? << Click Here >> for more details...
WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
- 4 Answers
- 8371 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 |
Why is group-clause used?
What are the examples of database management system?
Explain dml compiler?
What are the 4 main objects of a database?
What is the difference between a catalog and a database?
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
Explain the architecture of reporting services?
How to write udf s in delphi?
What is domain in dbms?
What is the use of ROWS option in IMP command ?
Can we save image in database?
Is sql a database?
-
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)
