This discussion is archived
1 2 3 Previous Next 36 Replies Latest reply: Dec 14, 2012 4:42 AM by ranit B RSS

finding length of column

newbie Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points