Skip to Content
author's profile photo
Former Member

Want to know the reason

Hi,

In an standard table 3 new fields are added,After the fields are added performance of the select single * from that table increased in huge amount.Can u tell me the reason for this..

thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 02:01 PM

    Can you tell which standard table u had appended.May be u can replace the * with the actual fields, it would help.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 02:05 PM

    hi

    good

    try to filter the select statement by providing the particular field name with the select statement or using move corresponding fields of table.

    thanks

    mrutyun^

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 04:19 PM

    Hi Narasimha,

    Did u create any indices to the newly added fields and are you using these fields in your where condition?

    Durga.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 04:23 PM

    Did you acivate and <u>adjust</u> the table?

    rob

    Add comment
    10|10000 characters needed characters exceeded