Toad World® Forums

dot lookup requery

When using the dot lookup for the colum names, it takes several seconds. I can kind of understand the first time. But then if I do it again for the same table, I would think the column names would be cached, but it seems like SQL is querying it all over again each time. In my case it was taking 4 seconds to get the list of names. I select one, put a comma, and do it again, it takes another 4 seconds. Then 4 seconds again on the next time. Can the names be cached so it is almost instant the second time?

Thanks.

-Charlie

Hi Charlie,

SQLNAV-1596 has been raised for it, once we get any improvement will let you know, thanks for your feedback. :slight_smile:

Regards,

Shirly