What are the types of optimization?
No Answer is Posted For this Question
Be the First to Post Answer
I need to write a simple query,which one is better select statement or stored procedure?and why?
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
what's the difference between a primary key and a unique key? : Sql dba
What is pl sql package?
Is join an inner join?
Why do we use set serveroutput on?
What is dml statement?
What is a cursor for loop ?
Which is faster union or join?
What is an index and types of indexes. How many number of indexes can be used per table ?
12 Answers Accenture, BirlaSoft, Cognizant, CTS, Symphony,
Query for second maximum salary in each in each department
15 Answers DST Global Solutions, TCS,
How does stored procedure reduce network traffic?
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)