What is a covered index?
No Answer is Posted For this Question
Be the First to Post Answer
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
Name 3 ways to get an accurate count of the number of records in a table?
How do you find the error, how can you know the number of rows effected by last SQL statement?
How to connect to a sql server using odbc_connect()?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Explain comment on transactions?
What is read uncmmited?
What is sub query and its properties?
Explain what are commit and rollback in sql?
Can you force a query to use a specific index?
What are the advantages of user defined function?
What are different types of join?
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)