RE: Query takes 1703.57 sec

2004-01-11 Thread Nawal Lodha
: Query takes 1703.57 sec In the last episode (Jan 11), Nawal Lodha said: > I have a query like - > > SELECT AdvElement.c_objectId , AdvElement.c_createdOn , > AdvElement.c_modifiedOn , AdvElement.c_elementType , > AdvElement.c_packageId , AdvElement.c_stereoTypeId , > AdvEl

Re: Query takes 1703.57 sec

2004-01-11 Thread Dan Nelson
In the last episode (Jan 11), Nawal Lodha said: > I have a query like - > > SELECT AdvElement.c_objectId , AdvElement.c_createdOn , > AdvElement.c_modifiedOn , AdvElement.c_elementType , > AdvElement.c_packageId , AdvElement.c_stereoTypeId , > AdvElement.c_objectType , AdvElement.c_versionNum