What are the different ways to optimize a sql query?
- 0 Answers
- 476 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Write a sql query to find the names of employees that begin with ‘a’?
what is collation? : Sql dba
How many sql statements are used?
What are the three pl sql block types?
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
how to include numeric values in sql statements? : Sql dba
what is purge command explain about oracle performance tuning
2 Answers Accenture, eCentric Solutions,
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is rownum?
What is use of term?
write a query to delete similar records in particular fields(columns) in different tables
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
-
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)
