[ADSM-L] Select on / dum/export of backups table

Hi,

I would like to do some queries on the backups table. I tried to run mefirst query however that takes really long and so far I didn't get aresult yet. I Iread that queries on the backups table aren't reallyspeedy or even possible.So how can I dump or export the whole table to a file? I cannot (do notwant to) use dsmc on the nodes as I would like to run the queries onserveral nodes on several platforms.Is there a way to enhance sql queries despite from using indexed fields(node_name in this case)?Let's say the query is like that (maybe this doesn't make sense it'sjust an example): select * from backups where node_name in (selectdistinct node_name from filespaces where filespace_name like'%ORACLE%') and class_name like 'MCLASS%'Is the performance better if the select in the where clause has thelast position?


Regards,

..--Egonle
________________________________________________________________________

Bei AOL gibt's jetzt kostenlos eMail für alle. Klicken Sie auf AOL.deum heraus zu finden, was es sonst noch kostenlos bei AOL gibt.