How can you fix a poorly performing query?
No Answer is Posted For this Question
Be the First to Post Answer
fact table and dimension table containg one to many relationship or many to one relastionship
agregator gives one to many records or many to one record
What is a join and explain different types of joins?
I have a few records all are same structures data, I want to store data in multiple targets how
0 Answers CTR, Infosys, Polaris,
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How to use online Backups?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
How can you fix a poorly performing query?
What are the three types of database design?
How to create an external table.
Who are naive users?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
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)