{"id":3812,"date":"2017-08-21T15:31:38","date_gmt":"2017-08-21T15:31:38","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-optimize-netsuite-saved-search-performance-with-indexed-fields-2\/"},"modified":"2026-07-28T18:26:08","modified_gmt":"2026-07-28T18:26:08","slug":"comment-optimiser-les-performances-des-recherches-enregistrees-dans-netsuite-a-laide-de-champs-indexes","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-optimiser-les-performances-des-recherches-enregistrees-dans-netsuite-a-laide-de-champs-indexes\/","title":{"rendered":"Comment optimiser les performances des recherches enregistr\u00e9es dans NetSuite \u00e0 l’aide de champs index\u00e9s ?"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Optimisez les recherches enregistr\u00e9es dans NetSuite en appliquant des filtres sur les champs couramment index\u00e9s.","ga_short_answer":"Pour optimiser les requ\u00eates de recherche enregistr\u00e9es dans NetSuite, privil\u00e9giez le filtrage selon les champs g\u00e9n\u00e9ralement index\u00e9s. Bien que la liste compl\u00e8te puisse varier, le fait de se concentrer sur les champs de transaction courants tels que \u00ab Compte \u00bb, \u00ab Date \u00bb, \u00ab Statut \u00bb et \u00ab Filiale \u00bb peut am\u00e9liorer consid\u00e9rablement la vitesse d\u2019ex\u00e9cution de la recherche. \u00c9vitez de filtrer de mani\u00e8re excessive sur des champs non index\u00e9s, ce qui peut ralentir l\u2019affichage des r\u00e9sultats.","ga_scenario":"Les utilisateurs rencontrent souvent des ralentissements ou des d\u00e9lais d'expiration lors de l'ex\u00e9cution de recherches enregistr\u00e9es NetSuite complexes, en particulier celles impliquant des ensembles de donn\u00e9es volumineux ou plusieurs crit\u00e8res. Ce probl\u00e8me survient g\u00e9n\u00e9ralement lorsque les recherches ne sont pas optimis\u00e9es pour tirer parti de l'indexation de la base de donn\u00e9es NetSuite, ce qui entra\u00eene une r\u00e9cup\u00e9ration inefficace des donn\u00e9es et des temps de traitement prolong\u00e9s.","ga_solution":"Pour am\u00e9liorer consid\u00e9rablement les performances des recherches enregistr\u00e9es dans NetSuite, en particulier pour les transactions, il est essentiel de filtrer les r\u00e9sultats \u00e0 l\u2019aide de champs g\u00e9n\u00e9ralement index\u00e9s par le syst\u00e8me. Bien que la strat\u00e9gie d\u2019indexation exacte de NetSuite puisse \u00e9voluer et qu\u2019une liste compl\u00e8te et exhaustive de tous les champs index\u00e9s par d\u00e9faut ne soit pas syst\u00e9matiquement publi\u00e9e, les champs suivants sont g\u00e9n\u00e9ralement consid\u00e9r\u00e9s comme de bons candidats \u00e0 l\u2019indexation sur les enregistrements de transactions et peuvent \u00eatre utilis\u00e9s en toute confiance pour optimiser les requ\u00eates de recherche. Il est important de noter que cette liste n\u2019inclut pas de nombreux filtres bool\u00e9ens ; on peut souvent supposer que ceux-ci sont index\u00e9s, ou bien leur indexation peut ne pas offrir d\u2019avantages significatifs en termes de performances si la r\u00e9partition des donn\u00e9es (par exemple, 50 % vrai, 50 % faux) ne se pr\u00eate pas \u00e0 une indexation efficace. De plus, cet aper\u00e7u ne couvre pas de nombreux index internes ou compos\u00e9s que NetSuite peut utiliser. Les champs de transaction couramment index\u00e9s susceptibles d\u2019am\u00e9liorer les performances de recherche comprennent : Compte, Classe, Cr\u00e9\u00e9 \u00e0 partir de, Devise, Date, Date de cl\u00f4ture, Date de cr\u00e9ation, Date d\u2019\u00e9ch\u00e9ance, Service, Employ\u00e9, Date de cl\u00f4ture pr\u00e9vue, Article, T\u00e2che, Date de derni\u00e8re modification, Source du prospect, Localisation, Nom (par exemple, client, fournisseur), Num\u00e9ro, Opportunit\u00e9, Partenaire, Mode de paiement, P\u00e9riode, Niveau de prix, Code promotionnel, Date d\u2019entr\u00e9e en vigueur de la vente, Mode d\u2019exp\u00e9dition, Statut, Filiale, Conditions, Type, Unit\u00e9, Motif de gain ou de perte. En donnant la priorit\u00e9 aux filtres sur ces types de champs, les utilisateurs peuvent optimiser efficacement leurs recherches enregistr\u00e9es dans NetSuite pour une r\u00e9cup\u00e9ration des donn\u00e9es plus rapide et plus efficace.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:31:38-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"How can I optimize a saved search query?","ga_ans_id":"ANS-0153","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The provided list of specific indexed fields (Account, Class, Created From, Currency, Date, Date Closed, Date Created, Date Due, Department, Employee, Expected Close Date, Item, Job, Last Modified Date, Lead Source, Location, Name, Number, Opportunity, Partner, Payment Method, Period, Price Level, Promo Code, Sales Effective Date, Ship Via, Status, Subsidiary, Terms, Type, Unit, Win Loss Reason) is not explicitly confirmed as entirely accurate and exhaustive in current NetSuite documentation. While current documentation emphasizes using indexed fields for optimization and provides examples like Internal ID, Transaction Number, Customer Name\/ID, and dates, it does not offer a comprehensive, up-to-date list of all standard indexed fields.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3812","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3812","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3812\/revisions"}],"predecessor-version":[{"id":5733,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3812\/revisions\/5733"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3812"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3812"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3812"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}