Re: Q: To check a record's existence in a table, FAST!

In article <335b45b1.12345729_at_news.netvigator.com>

           budlo_at_netvigator.com "Bud Lo" writes:

> Hi all,
>
> My requirement is very simple.
>
> To check a record's existence in a table. ( i am using Oracle 7)
>
> Obviously, this SQL will do:
>
> select count(*) into nCount from table where ColA='ABC';
> .......

Consider building an index on ColA.

David M. Kurtz

  o__    home: david_at_kurzbyrn.demon.co.uk  voice: 0118-9462515
 _,>/'_  work: david_kurtz_at_peoplesoft.com  voice: 0118-9521320
(_) \(_)  web: http://www.kurzbyrn.demon.co.uk