Interested to Buy Any Domain ? << Click Here >> for more details...
Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 8035 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jayesh
WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / mohapatra.gouranga@gmail.com
1) Find the cost.
2) Check what tables are going full table scan.
3) Create Indexes if is possible.
4) Re-write the query to optimize the cost with modifying
filter condition.
| Is This Answer Correct ? | 0 Yes | 0 No |
What view would you use to look at the size of a data file?
when does an alert gets signaled?
what are the differences of where and if in SAS?
How can we know the exact updation date of a particular database?
Give two methods you could use to determine what DDL changes have been made.
how do see how much space is used and free in a tablespace
what is the role of dip user in our database?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
Which autogrowth database setting is good? : sql server DBA
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
What are the steps you will take to improve performance of a poor performing query?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
-
Oracle (3253) - 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)
