table retrieval problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: table retrieval problem

  1. #1
    Join Date
    May 2002
    Posts
    13

    Arrow

    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

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    By the way, what's a "lakh"?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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

  5. #5
    Join Date
    Apr 2002
    Posts
    55
    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.

  6. #6
    Join Date
    May 2002
    Posts
    13
    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


  7. #7
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    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.

  8. #8
    Join Date
    May 2002
    Posts
    13
    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
  •  



Click Here to Expand Forum to Full Width