Query processing is slow(eg select query)how will u solve that
Answer Posted / jayesh
WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is logical system in sap basis
What are the different sql server versions you have worked on? : sql server DBA
what is the role of dip user in our database?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
what do you understand by fine-grained auditing?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Explain about your sql server dba experience? : sql server DBA
what are the benefits of flashback feature?
how can you initialize log miner?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?