Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 6500 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 |
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How would you extract DDL of a table without using a GUI tool?
Name two files used for network connection to a database.
What are the operating modes in which database mirroring runs? : sql server DBA
what are the performance views in an oracle rac environment?
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
why do we give pctfree and pctused in create table statement?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How do you add a data file to a tablespace?
How would you go about verifying the network name that the local_listener is currently using?
What is transparent data encryption? : sql server DBA
what is difference between user managed backup and rman backup?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
