will where conditions in a sql query help improve performance?

Answer Posted / inder mohan

Yes, It will fetch only that data which will be in that
with criteria.

Inder Mohan Singh
9810058416

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages and disadvantages of different types of bdc's?

545


Hi, I have a requirement for locking the fax field in user master records. As you know user can edit the details using the System>profile>own data (SU3), it is causing some security threat to our model. What i want is users should not be able to change the fax field under communications when they get into su3.I have heard of user Exist functionality but don't know how to implement it. Can you suggest something, it will be greatly appreciated.

1463


A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?

872


What is sapnet?

887


WHY CLUSTER TABLE CALLED AS CLUSTER TABLE.

1637






What is an interactive report? What is the obvious difference of such report compared with classical type reports?

563


What are the attributes of a field that can be activated or deactivated during runtime?

566


What is direct input method ?

1476


In sap script how to print bar code in vertical manner

2632


B -Credit Note report Selection Screen Ranges: Creation date Sales Org Sold to Party Selection condition: Document Category – VBTYP should be ‘O’ Table to be used: VBRK, VBRP,VBPA,ADRC List the CR order types or credit billing type by customer number (or selected customer) and displays the: - Billing Document date (FKDAT) - Customer number (KUNRG) - Name of the reseller (on top of the SAP No) (NAME1) - Billing document number,(VBELN) - order reason (AUGRU_AUFT) - Amount (NETWR) - Currency (WAERK) Group Currency wise, billing type wise sum of Net value. When user double click on field ‘Billing Document #’ , display the document in VF03 Do this using OO ABAP.

2462


Explain how data is stored in cluster table?

664


Mention what is alv programming in abap?

587


After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then ?

1455


What are the page windows? How many main windows will be there in a page window?

561


What will happen when we use fully buffered in abap?

563