1 2 3 Previous Next 36 Replies Latest reply: Dec 14, 2012 6:42 AM by ranit B RSS

    finding length of column

      Hi experts

      I am firing a simple query against a huge table which have more than 500,000,000 records. here am finding the records length which have more than 10. But it is taking too much time to execute and the other thing is that it dont have any indexes . Please check my query.

      select max(length(ename)) from emp; -- i got 12

      and to find out the count of records which have length more than 10 am firing the below query.

      select count(ename) from emp where length(ename)>10; --it is taking too much time to execute ...more than 5hrs and it is still running.

      Please let me know is there any better query.

      Many thanks
        1 2 3 Previous Next