Skip to Content
0
Former Member
Nov 23, 2005 at 10:39 AM

Performance issue

27 Views

Hi,

I have a Custom table for USERDETAILS, on which I am fetching data using

SELECT ecno bname department l1name l2name bukrs

FROM yusrdetail

INTO TABLE vt_yusrdetail1

WHERE essid IS not NULL

AND department IN s_dept

AND bukrs IN s_bukrs.

Here how can I improve performance of this Query with out creating index on DEPT and BUKRS.

INDEX is already existing on ESSID.

Here BNAME is the only Primary Key available on this table.

It is very urgent Plz....

Thanx

K P