WE CREATE PROCEDURE THEN ACCESS IT INDEXING ALSO DONE

Query processing is slow(eg select query)how will u solve that

Question Posted / jayesh

Answer Posted / jayesh

WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can you control the amount of free space in your index pages? : sql server DBA

740

Where would you look for errors from the database engine?

2356

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2002

What are the different sql server versions you have worked on? : sql server DBA

547

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2193

How would you go about verifying the network name that the local_listener is currently using?

2764

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1750

What is fill factor? : sql server DBA

647

what are the types of connection load-balancing?

564

how can you process messages in order asynchronously?

557

What are the recovery models for a database? : sql server DBA

593

what is a user-defined lock?

590

Why does Oracle not permit the use of PCTUSED with indexes?

2329

What happens on checkpoint? : sql server DBA

564

What is the default port no on which sql server listens? : sql server DBA

562