What is SQL Index ?

Answer Posted / vamsi mohan

Indexes in databases are very similar to indexes in
libraries. Indexes allow
locating informatio within a database fast, muchlike they
do in libraries.

Example:- create index <index_name> on proudct (model)

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an audit report? Whom is it done by?

1942


what are metrics and what are metrics did u collect in you are project

1913


do we need to write test cases for workflow of the product for instance: there is 2 module "TRAINING ASSIGN MODULE" and "EMPLOYEE" in TRAINING assign MODULE iam assigning training to employee setp is 1.selct traning "oracle" 2.select employee u want assign "peter" 3.apply. now to check whether training assign or not GOTO EMPLOYEE module 1.click on "peter" 2.click on 'view assign to employee'link.now this is a flow do i need to write test cases for this fllow.plz help me guy mail me nirmal_rawatt@rediff.com

1572


could any body plz let me know which is best training institute for telecome testing in hyderabad?

1505


how to write manual testcases for download the files from the template. for example:from product cost enddate

1658






How we test the bulk of contents in web page using manual testing? Is any open source tool available for that ? Thanks in advance..

1510


What is Difference between Test Strategy and Test Methodology?

1715


Different types of design diagrams that supports to write test cases ?

1856


What are the different ways to check a date field in a website?

659


Hi Friends, I have completed 3 rounds of an Interview with HR discussion also and got Offer letter from Cognizant, but after in 30 min they send one more email like Offer is on Hold, and its not valid... Could you please guide me any one , Can i expect Offer again from Cognizant or Can i drop the hopes ?.

1359


What are the basic forms of variations?

1674


Test approach to windows update?

1729


hi sir, i completed my GNIIT from NIIT. i recently joined in IT company for Testing(manual) on JD EDWARDS.So,i wanna to ask that after taking 1yr experience can i able to do Testing .NET in another company.Pl i am confused pl send yours suggestion throw my email(paresh_shindeal@yahoo.com)

1511


If I want to check compability of software in a MAC OS then which steps shold I follow?

1580


Define cause effect graphing?

672