How you can find out if an index is useful to the optimizer?
No Answer is Posted For this Question
Be the First to Post Answer
What is the use of stored procedure?
What is merge join?
Explain how many types of relationship?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
How many types of system privileges are there, Can we add or delete privileges?
What is the difference between UNIQUE and DISTINCT keywords in DBMS?
What are the types of dml?
Who developed sql server?
What happens on checkpoint?
What is index?
Write a code to select distinct records without using the DISTINCT keyword.
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
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)