Answer Posted / dai
AFTER INDEXING ALSO WHEN THE TABLE ACCESS
WILL BE SLOW ie. THE PERFORMANCES is low
we need to denormalize
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the difference between inner join and natural join?
What is a sql profiler?
What is the difference between sum and count in sql?
What can sql server reporting services do?
What are tables and fields?
Explain aggregate functions are available there in sql?
what is oltp (online transaction processing)? : Sql dba
Define implicit and explicit cursors.
differentiate between float and double. : Sql dba
tell me about various levels of constraint. : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is primary key and foreign key?
What is the syntax to add a record to a table?
Explain the commit statement.
What is java sql driver?