-
HI
i'm accessing data from huge table having record more than 50 lakh. average row size is 52 byte. While executing explain plan on this it's showing that this table is accessed by full index scan, but it is taking 1minute to retrieve data.I want to bring down the retrieval time. can anybody suggest.
thanx in advance
-
Do you really need to look at every record in the table, even if the values are stored as keys in an index?
A range scan would be preferrable, but you will need some constriction on the key values.
If you could provide the code it would help give you better, more specific suggestions.
-
By the way, what's a "lakh"?
-
Its a Hindi word
Lac \Lac\, Lakh \Lakh\, n. [Hind. lak, l[=a]kh, l[=a]ksh, Skr. laksha a mark, sign, lakh.] One hundred thousand; also, a vaguely great number; as, a lac of rupees.
pras
-
Hi,
Lakh is number value given in Hindi but now it exists in English Dictionary also : http://www.websters.com
Lakh = 100,000
Take Care.
-
Hi
the query is like this
SELECT DISTINCT EMPLOYEENO
FROM TIMESHEETENTRY
WHERE EMPLOYEENO > 0
AND PROJECTID = 212200583
AND
ENTRYDATE >= TO_DATE('2002-04-01','YYYY-MM-DD')
AND ENTRYDATE <= TO_DATE
('2002-04-26','YYYY-MM-DD');
thanx
-
Originally posted by mmbiswal
Hi
the query is like this
SELECT DISTINCT EMPLOYEENO
FROM TIMESHEETENTRY
WHERE EMPLOYEENO > 0
AND PROJECTID = 212200583
AND
ENTRYDATE >= TO_DATE('2002-04-01','YYYY-MM-DD')
AND ENTRYDATE <= TO_DATE
('2002-04-26','YYYY-MM-DD');
thanx
Why Dont u use between operator for date.Thats better.
Take Care.
-
thanx nishant i'll try to use ur suggestion.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|