Differentiate nested loop, hash join and merge join.
- 0 Answers
- 560 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
What do you understand by cursor? Mention the different types of cursor?
What is stored in a database?
Is declare cursor executable?
Do I need ccp4?
How data are stored in database?
What is stored procedure in database?
What are the types of database management system?
What are the examples of database?
What do you mean by cardinality and its types?
What does <> mean in database?
Should database table names be capitalized?
-
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)
