Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    5

    Unanswered: Performance: Empty Table check

    Hi,

    what is the best way to check that a table is empty?

    I have procedure with the following statement:
    select count(*) into v_count from test_abc_prices;
    then i'm checking whether count(*) >0:

    if (v_count > 0) then null
    Is there a more efficient way?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As you've already seen on another forum, using the ROWNUM would probably be the fastest way to do it.

  3. #3
    Join Date
    Oct 2005
    Posts
    5
    yepp, that's right.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •